| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy cells
I have a column of cells (in the thousands) that I need to add
' to. Cant figure out the way to do it. Any suggestions? Thanks in advance. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy cells
Insert a helper column to the right of the column that needs the suffix added
to it and enter the following, changing the A1 in the formula to the starting cell of your data column: " Copy this down the column as far as necessary and then do the following: Copy the entire column of formulas and move to the first cell of original column of data. Click EDIT in the menu and select PASTE SPECIAL. Click the VALUES option button and then click OK. Your original values have been replaced by the formula values. Delete the helper column that has the formulas and you're back in business. -- Kevin Backmann "biffula" wrote: I have a column of cells (in the thousands) that I need to add ' to. Cant figure out the way to do it. Any suggestions? Thanks in advance. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy cells
The same way as when you asked the same question in the same group
yesterday. -- David Biddulph "biffula" wrote in message oups.com... I have a column of cells (in the thousands) that I need to add ' to. Cant figure out the way to do it. Any suggestions? Thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy and paste versus copy and insert copied cells | New Users to Excel | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| how can we copy cells comments text and paste to cells | Excel Discussion (Misc queries) | |||
| How to use macros to copy a range of cells which can exclude some cells which I didn't want to be copied? | Excel Worksheet Functions | |||
| Copy cells into range of cells until cell change | Excel Worksheet Functions | |||
Hybrid Mode
