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
Manu
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".
