Copying & pasting formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Count, Sum, Index,Match or other formula needed 1
Formula that works like text-to-column 6
How to count after 2 conditions are met 3
How to filter unique entires in a column when differnet entires in 13
Scrabble Value calculation for Welsh words 0
Data Matching 1
Duplicates-to id when occurs in 3 columns for unique dup in 4th co 1

Back
Top