| 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
" and copy down. If you don't need to keep the original you
can Copy, Edit/ Paste Special/ Values, and delete the unwanted column. -- 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy cells
One eqasy way is to use an auxilary column to add the suffix and then copy
the new colum back to the old column. If your data is in Column A but in to column B =A1 & " then copy formula down the entire column B. Then you can copy this new row back to the old row. "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. |
| 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 | |||
Linear Mode
