If not 11, then 12.....

[stinebjor]

Hi,

I have a lot of data in one cell, I want to split this data into different two columns. I want to split the cell in a specific place. The information in each cell varies throughout all the cells in the column.

Example:
A1 contains : 1389177528**r2*r1,r0*0
A2 containts : 1388757953*r2*r1*r0*0

I want to split these two different cells right before the first * symbol. However, as you can see: A1 has ** whereas A2 has * and A1 contains a comma whereas A2 doesn't... How do I split these cells into one column containing only the first 10 digits and the next column contains whatever is left? Like this:

A1: 1389177528 B1: **r2*r1,r0*0
A2: 1388757953 B2: *r2*r1*r0*0

Lastly, my doucment is massive and contains several of these cells in columns that I want to split. Is there a command that will save me from splitting one column at the time and performs the command for the whole document in one go?

Very very much appreciate any help I can get!

[Special-K]

To get the first ten characters

=LEFT(A1,10)

To get the remainder

=RIGHT(A1,LEN(A1)-10)