insert symbols in text cell

S

SelinaT

i would to insert "-" to the text cell format, how to do?
example:

123456 change to 123-456
 
S

SelinaT

Try in B1: =LEFT(A1,3)&"-"&RIGHT(A1,3)
i have try, if i have middle like:
12345123
123-45-123, how to do with this problem?

can use custom on format cell?
 
S

SelinaT

did u key in at the custom on format cell, i have try but cannot work!
my cell is text format.
 
S

SelinaT

thank you! :)
Max said:
In B1: =LEFT(A1,3)&"-"&MID(A1,4,2)&"-"&RIGHT(A1,3)
Copy down


Since the numbers in col A are text,
we can put in say, C1: =A1+0
then format C1 as Custom: 000-00-000
and copy C1 down

For both ways, the assumptions that the data posted & desired
transformation
is representative down the col applies. If it's not, it won't work.
Click to expand...
 
Top