ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Add single fuction to end of multiple cell column (https://www.excelbanter.com/excel-discussion-misc-queries/114745-add-single-fuction-end-multiple-cell-column.html)

Mead1

Add single fuction to end of multiple cell column
 
Is it possible to add: " to the end of a list of names in a single
column? A sort of copy/paste to an entire list in Excel?

CLR

Add single fuction to end of multiple cell column
 
If your names are in column A, put this in B1 and copy down

"

Then you can do Copy PasteSpecial Values on column B to get rid of the
formulas and just leave the text in column B

hth
Vaya con Dios,
Chuck, CABGx3


"Mead1" wrote:

Is it possible to add: " to the end of a list of names in a single
column? A sort of copy/paste to an entire list in Excel?


Dave Peterson

Add single fuction to end of multiple cell column
 
You may even want to use:
")

Mead1 wrote:

Is it possible to add: " to the end of a list of names in a single
column? A sort of copy/paste to an entire list in Excel?


--

Dave Peterson


All times are GMT +1. The time now is 11:14 AM.

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