Using Built-In Excel Functions Another way to split data into multiple columns is to use some of Microsoft Excel's functions. If you choose this route, remember that the split values will be ...

Select Delimited and click Next. Tick the Space checkbox. If a different delimiter, such as a comma or hyphen, separates the first and last names, select the appropriate option. Then, click Next.