text to columns

[uzbeklana]

I am trying to sort out some information by separating a column which contains numbers like 1-xxx and xxxx. Most of the numbers that don't have a "1-" in front of it have three zero's and then another number (e.g. 00000, 00009). I want to retain those 0's. I have the column in "text" form so it will do so. BUT, when I do the text to columns with the "-" as the delimited character, the 00000 turns into 0 or 00009 turns into 9, which is precisely what I don't want.
Suggestions on what to do, please?

 

[Aladin Akyurek]

I am trying to sort out some information by separating a column which contains numbers like 1-xxx and xxxx. Most of the numbers that don't have a "1-" in front of it have three zero's and then another number (e.g. 00000, 00009). I want to retain those 0's. I have the column in "text" form so it will do so. BUT, when I do the text to columns with the "-" as the delimited character, the 00000 turns into 0 or 00009 turns into 9, which is precisely what I don't want.
Suggestions on what to do, please?

You could use a formula set like...

B2:

=LEFT(A2,SEARCH("-",A2)-1)

C2:

=REPLACE(A2,1,SEARCH("-",A2),"")