Excel's Text to Columns: Name List as Example

Forum to talk about all the latest technologies - ins and outs!!
Post Reply
Admin
Site Admin
Posts: 325
Joined: Tue Sep 25, 2007 12:41 pm

Excel's Text to Columns: Name List as Example

Post by Admin »

Microsoft Excel's Text to Columns is a powerful feature that can split texts into multiple columns. You find it under Data > Data Tools > Text to Columns . With the keyboard shortcut ALT + A + E you can also access this feature.

Image


In the following example, I will separate the list into first name, middle name and last name. It's a three step procedure.


First, select your data set (A2:A9).


Image


Under Data tab > from the Data Tools group click Text to Columns. This will open the Convert Text to Columns Wizard. Look, every wizard has a Data preview window to see how your data is taking new shape :-)


Step 1: select Delimited > click on Next. By default Delimited is always selected.


Image


Step 2: select Comma and Space as your Delimeters. You will see an immediate change in the Data preview window below. Click Next.


Image


Step 3: select cell B2 as your Destination > click Finish.


Image


Your results are now displayed in cell B2.


Image




*Short note: What are delimiters?

Delimiters are characters like commas ( , ), semicolon ( ; ), slashes ( / ) or special signs like @ that separate each field in your data. In this example Comma and Space are your delimiters.

So, have fun my friends :-)
Post Reply