Add single fuction to end of multiple cell column

M

Mead1

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

CLR

If your names are in column A, put this in B1 and copy down

=A1&"@place.edu"

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
 
Top