adding text ?

[picassofacepicassoface is verified member.]

say i had a long list of first names :

john
bill
fred
amanda
etc....

How can I add the same word to all of them in 1 quick step ?

ie:

johnSMITH
billSMITH
fredSMITH
amandaSMITH

can you do it in notebook or exel ? how ?

Thanks !!!!!!!!!!!!!!!

 

[draggar]

Excel and word -

Put them in rows 1 and 2 in Excel then save as text, tab delimited.

Then, open it with Word and use the find / replace function - find "tabs" (easier to copy and paste the empty tab) and replace it with nothing.

You should be able to do this with Open Office, too.

 

[Bionic]

I forget how to use Excel but can't you make a third column with a formula like
=concat(A1,B1)

I think Adam asked the same question a couple months ago.