Spliting lines of data in a cell into columns

fanfan - Aug 5, 2010 at 09:10 PM
 Trowa - Aug 6, 2010 at 09:27 AM

I would like to know how can I go about extracting lines of data in each cell of a partocular column and split them into various columns. For instance:

Name: Adam Robert Que
Gender: Male
Origin: Sumatra, Indonesia
Years of exprience: 7.5

Hence, I want the data to be split into 4 columns. Please help me.

Thank you

1 reply

Hi Fanfan,

I am not sure how you would like your data to look like, but let me give you some tools which may get the job done.

Separate heading from data:
Select your data, goto the top menu's Data, select Text Delimiter, click next on the screen that pops up, select remainder and enter ":". Now the example shows how your data is going to look like. Click finish and you are done.

Change column to rows:
Copy your data, right click, paste special, transpone (option at the bottom right) and click OK.

Can you do something with this?

Best regards,