insert symbols in text cell

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"SelinaT" <SelinaT.26jyta_1145519400.5296@excelforum-nospam.com> wrote in
message news:SelinaT.26jyta_1145519400.5296@excelforum-nospam.com...
>
> i would to insert "-" to the text cell format, how to do?
> example:
>
> 123456 change to 123-456
>
>
> --
> SelinaT
> ------------------------------------------------------------------------
> SelinaT's Profile:
http://www.excelforum.com/member.php...o&userid=33675
> View this thread: http://www.excelforum.com/showthread...hreadid=534451
>

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?

Format as 000-000

HTH
--
AP

"SelinaT" <SelinaT.26jyta_1145519400.5296@excelforum-nospam.com> a écrit
dans le message de
news:SelinaT.26jyta_1145519400.5296@excelforum-nospam.com...
>
> i would to insert "-" to the text cell format, how to do?
> example:
>
> 123456 change to 123-456
>
>
> --
> SelinaT
> ------------------------------------------------------------------------
> SelinaT's Profile:
http://www.excelforum.com/member.php...o&userid=33675
> View this thread: http://www.excelforum.com/showthread...hreadid=534451
>

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

Originally Posted by Ardus Petus

Format as 000-000


HTH
--
AP

"SelinaT" <SelinaT.26jyta_1145519400.5296@excelforum-nospam.com> a écrit
dans le message de
news:SelinaT.26jyta_1145519400.5296@excelforum-nospam.com...
>
> i would to insert "-" to the text cell format, how to do?
> example:
>
> 123456 change to 123-456
>
>
> --
> SelinaT
> ------------------------------------------------------------------------
> SelinaT's Profile:
http://www.excelforum.com/member.php...o&userid=33675
> View this thread: http://www.excelforum.com/showthread...hreadid=534451
>

> 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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

thank you!

Originally Posted by 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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

You're welcome !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"SelinaT" wrote:
>
> thank you!