PDA

View Full Version : split cell value ( Name & Number separately)



pmari
10-10-2011, 06:21 AM
Hi friends,

I am having file with one column, like below

Col A
Aditya +91900000001"
Advocate"09840190866"04424610014"
Airdeccan Mum"0900000008"
Alag""040000000001"

I need to split Like below

ColA ColB Col C
Adity 91900000001
Advocate 9840190866 4424610014
Airdeccan Mum 900000008
Alag 40000000001

Alag 40000000001

Please help out , any help highly appreciated.

Bob Phillips
10-10-2011, 06:53 AM
Data>Text To Columns with delimiters of space and "

pmari
10-10-2011, 08:02 AM
Dear XLD,

Many thanks for quick response. Can you please elaborate your answer, i am not able to understand.

Bob Phillips
10-10-2011, 09:20 AM
Goto Data>Text To Columns and follow the wizard.