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

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)

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

& is the concatenate character so

=A1 & " Cisco"

should work...
--
HTH...

Jim Thomlinson


"future spreadsheet master" wrote:

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)

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

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

On Aug 20, 4:09*pm, future spreadsheet master
wrote:
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)