Cell Split
Posted by Barry on June 19, 2001 7:40 PM
How do I take a column with 6 digits (xxx-xxx) and cut out the second group of 3, and paste them into the ajoining cell and remove the dash.
ie:
A1 B1
631-458
631 458
I have tried a macro but it just seems to work on one cell and find and replace takes to long and...
Thanks,
Barry
Posted by Richard S on June 19, 2001 7:46 PM
in cell B1, = left(a1,3), in cell C1, right(a1,3). Then copy and past the values back into column A & B
Posted by Martin on June 20, 2001 4:18 AM
Barry,
If you go into the cell with the numbers that you want to split and then go to the 'Data' menu and select 'Text to Columns' Follow the steps, the best way in this case would be to say that it is delimited by a - and this way you will get two columns of numbers and no -
