Copying & pasting formulas

S

Shawn

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
 
S

Shawn

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

Peo Sjoblom

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
 
Top