MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Split a cell

Posted by Manu on April 04, 2001 7:11 AM

Further to my previous question, how can I take partial values from a cell to another cell(opposite of concatenation) e.g.

lets say I have a column of cells with data in format A2A2A2. Now I need to split this column into 2 columns with data in column1= A2A and in column2=2A2

I would like to thank you all experts for the time and patience


Posted by Mark W. on April 04, 2001 7:20 AM

...this can be easily accomplished using the
Data Text to Columns menu command.

Posted by Barrie Davidson on April 04, 2001 8:34 AM

There are three functions that you could also use: "mid", "left", and "right".