ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   copy cells (https://www.excelbanter.com/excel-discussion-misc-queries/164785-copy-cells.html)

biffula

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.


David Biddulph[_2_]

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.




joel

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.




All times are GMT +1. The time now is 04:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com