Separating digit of numbers into each cell?

Separating

Hello everyone, as you can see in the picture;

it is possible to separate numbers from Column A into each column of B and C?

In B1 this: =LEFT(A1,3)
In C1 this: =RIGHT(A1,3)
and drag them down

If you want the results to be numeric just add *1 to each formula

Originally Posted by cutter

in b1 this: =left(a1,3)
in c1 this: =right(a1,3)
and drag them down

if you want the results to be numeric just add *1 to each formula

dang! Thanks again cutter !

WAIT! what if I have 72-120 in A1, also what if I have 1-2 in A1?

I don't want the dash sign include it.

I figured that would be the next question.

so now it would be:
In B1: =LEFT(A1,FIND("-",A1)-1)
and if the length after the "-" is variable then
In C1: =RIGHT(A1,LEN(A1)-FIND("-",A1))

Originally Posted by Cutter

I figured that would be the next question.

so now it would be:
In B1: =LEFT(A1,FIND("-",A1)-1)
and if the length after the "-" is variable then
In C1: =RIGHT(A1,LEN(A1)-FIND("-",A1))

LMAO, you must be for FORTUNE TELLER!

Hey sorry man but the formula didn't work well like this formula Haseeb gave it to me.

B1,

=left(a1,find("-",a1)-1)

c1,

=mid(a1,find("-",a1)+1,250)

here is my data..


187-474
135-337
96-206
90-199
77-217
68-109
39-110
33-102
22-58
24-61
14-48
20-51
3-19
2-17
188-438
163-375

thank you Haseeb and Cutter, you are great thank you for helping me.

Originally Posted by jeffreybrown

Why not just use Text to Colums on data that looks like what you posted?

Use the - as the delimiter

how you use text to columns?

ok never mind, i figure it out...
i'm so exxcel noob LOL!

thank you EVERYONE!!!!!!!!!!!!!!!

Got it , thanks jeffrey

There's also this for C1

=SUBSTITUTE(A1,LEFT(A1,FIND("-",A1)),"")

Originally Posted by Cutter

There's also this for C1

=SUBSTITUTE(A1,LEFT(A1,FIND("-",A1)),"")

hey both your function work. thank you cutter!

=LEFT(A1,FIND("-",A1)-1)

&

=SUBSTITUTE(A1,LEFT(A1,FIND("-",A1)),"")