insert symbols in text cell

[SelinaT]

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

123456 change to 123-456

 

[Max]

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

 

[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?

 

[Ardus Petus]

Format as 000-000

HTH
--
AP

"SelinaT" <[email protected]> a écrit
dans le message de
news:[email protected]...

 

[SelinaT]

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

 

[Max]

12345123

123-45-123, how to do with this problem?

In B1: =LEFT(A1,3)&"-"&MID(A1,4,2)&"-"&RIGHT(A1,3)
Copy down

can use custom on format cell?

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.

---

 

[SelinaT]

thank you!

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.

---

 

[Guest]

You're welcome !