I have a column of data, several hundred lines long, that has 10 digits in
each cell (1234567890) and I want to use the formula
=LEFT(A1,3)&"-"&MID(A1,4,3)&"-"&MID(A1,7,3) to make the data look like
123-456-789. I need to copy and paste the formula to a set of helper cells
but don't know how to copy & paste the formula.

Any help would be greatly appreciated.

Thanks

PS - I want to be able to delete the 1st column of data and keep the new
formulated data.

"Shawn" wrote:

I have a column of data, several hundred lines long, that has 10 digits in
each cell (1234567890) and I want to use the formula
=LEFT(A1,3)&"-"&MID(A1,4,3)&"-"&MID(A1,7,3) to make the data look like
123-456-789. I need to copy and paste the formula to a set of helper cells
but don't know how to copy & paste the formula.

Any help would be greatly appreciated.

Thanks

The formula itselef can be simplified

=TEXT(LEFT(A1,LEN(A1)-1),"000-000-000")

to paste values (regardless of what formula you are using), copy
then paste special as values

--

Regards,

Peo Sjoblom


"Shawn" wrote in message
...
I have a column of data, several hundred lines long, that has 10 digits in
each cell (1234567890) and I want to use the formula
=LEFT(A1,3)&"-"&MID(A1,4,3)&"-"&MID(A1,7,3) to make the data look like
123-456-789. I need to copy and paste the formula to a set of helper cells
but don't know how to copy & paste the formula.

Any help would be greatly appreciated.

Thanks