There are times when you receive a data set of employee full names in one column and you want to separate the full name into first name and surname in separate columns.

One way is to use the Power Query method, which is great if you have lots of data that gets added each day, week or month and simply want to Refresh your Query to get the output needed each time.

If you want to quickly split a cell’s full name into separate columns on an ad-hoc basis, then the Text to Columns is the way to go.

DOWNLOAD EXCEL WORKBOOK

 

STEP 1: Highlight your column’s data that has the full names

highlight data

 

STEP 2: Go to Data > Text to Columns

text to columns

 

STEP 3: In Step 1 of 3 you need to select the Delimited button and press Next

step 1

 

STEP 4: In Step 2 of 3, you need to “check” the Tab and Space boxes and press Next

step 2

 

STEP 5: In Step 3 of 3 you need to press the Finish button

step 3

 

This will split the column into two columns, separating the first from the second name.  You can go ahead and change the column headings to get the following result:

FINAL

Text to Columns - Full Names

HELPFUL RESOURCE:

Jeff_Lenning

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+