Return number into separate cells

[serge]

Hello, I'm looking for formulas that will separate a 3 or 4 digits number into 3 cell, like the example here if I have the number 6104, the 6 would be in the 1st cell A2 the 10 in B2 and 4 in C2 but the problem is that with my data I get sometime 3 digits number or 4 digits number so I don't get the right return in B2 with this formula :

A2 =MID(TEXT(A1,"000"),1,1)+0
B2 =MID(TEXT(A1,"000"),2,2)+0
C2 =MID(TEXT(A1,"000"),3,2)+0

A2 and C2 are Ok but B2 I have a problem because of the 2 centered digits, could this be solve ? Thank you.

 

[Joe4]

Try these three:

A2: =LEFT(A1,1)
B2: =MID(A1,2,LEN(A1)-2)
C2: =RIGHT(A1,1)

 

[serge]

WOOOWW, Thank you so much Joe4, this really help me, I appreciate you, quick response and accurate.
Thanks.

 

[Joe4]

You are welcome.
Glad I was able to help!