insert symbols in text cell

> 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!