insert symbols in text cell

  • Thread starter Thread starter SelinaT
  • Start date Start date
S

SelinaT

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

123456 change to 123-456
 
Assuming the data posted is representative
(6 digits, with dash to be inserted in centre)
and running in A1 down

Try in B1: =LEFT(A1,3)&"-"&RIGHT(A1,3)
Copy down

Then copy col B, and overwrite col A
with Paste special > Values
Then clear col B
 
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?
 
did u key in at the custom on format cell, i have try but cannot work!
my cell is text format.
 
12345123
123-45-123, how to do with this problem?
Click to expand...

In B1: =LEFT(A1,3)&"-"&MID(A1,4,2)&"-"&RIGHT(A1,3)
Copy down
can use custom on format cell?
Click to expand...

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.

---
 
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...
 
Back
Top