Instead of splitting the numbers up and concatenating them, how about just
giving the cells a special format.

Select the range
format|cells|number tab|Special|phone number.
or
format|cells|number tab|custom
and type:
000-000-0000
in the type box.

But if you want, you can join them with something like:

=text(b1,"000")&"-"&text(c1,"000")&text(d1,"0000")

NDF wrote:

I am trying to delimited 1,240 rows of numbers which I need to separate as
phone numbers. I need the phone numbers to be written as 314-923-0417. Right
now the number is written as 3149230417. My problem is when I delimite, the
system will leave off the 0 thus giving me 314-923-417 after I concatenate
all my phone numbers with a 0 in the parameter are missing the 0's. I have
tried formating the column as text, then as special formating. So far
nothing has worked. If anyone knows how to accomplish this task please please
let me know. Thank you.

--

Dave Peterson