| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Copying & pasting formulas
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pasting data without removing formulas | Excel Discussion (Misc queries) | |||
| Copying and Pasting between Workbooks | Excel Worksheet Functions | |||
| Pasting numbers and formulas without pasting format. | Excel Discussion (Misc queries) | |||
| Excel Error when copying formulas | Excel Worksheet Functions | |||
| Excel 2002 - copying formulas across worksheets | Excel Discussion (Misc queries) | |||
Threaded Mode
