Adding one word onto the end of text a column of cells

  • Thread starter Thread starter future spreadsheet master
  • Start date Start date
F

future spreadsheet master

I need to add the word "Cisco" at the end of a site name, but I have 4000
cells that need it added. Is there a formula that will allow me to add the
word in??

Ex:
1234 Main St needs to be 1234 Main St (Cisco)
1549 Rough St needs to be 1549 Rough St (Cisco)
 
Assuming those addresses are in column A, use this in a helper column:

=IF(A1="","",TRIM(A1&" (Cisco)"))

Then you can copy it down that column as far as you need to.

If you fix the values using <copy> | Edit | Paste Special | Values |
OK then <Esc>, then you will be able to copy/paste the values over the
original ones in column A, and then delete the helper column.

Hope this helps.

Pete
 
Back
Top