If you want to parse strings such as "First Last" into separate columns, you don't need to use fancy formulas. Excel has a tool that makes the job a snap. In “Save time by using Excel’s Left ...

Microsoft Excel isn't a text-parsing program, but you can use it as a parser to create tab-delimited and comma-delimited files. Open an application that contains the text you'd like to parse, ...

Before Flash Fill, you might have used a combination of string functions: RIGHT(), FIND() ... How to parse entries into multiple columns in Excel. With a simple example behind us, ...