Source data won't always come in the form you need in Excel. When that happens, consider using Flash Fill to save time and aggravation.

How to use Flash Fill to parse characters across multiple columns in Microsoft Excel Your email has been sent We may earn from vendors via affiliate links or sponsorships. This might affect ...

How to use Excel’s Flash Fill feature, including a keyboard shortcut for both Windows and Excel for Mac.