UN-concatenate

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I have a string of numbers.....123456789, all in one cell.

How can I split, or un-concatenate this cell into three
cells? i.e. 123 456 789

Thank you.
 
Dave

There are several ways, all depends on the consistency of
the number... if it is always a 9 digit figure then you
can use:

A1: 123456789
B1: =LEFT(A1,3)
C1: =MID(A1,4,3)
D1: =RIGHT(A1,3)

Or you can go to DATA > TEXT TO COLUMNS >
Then check on fix and locate the splits where you want
them.

Cheers
Juan
 
Back
Top