Excel help

[bwhhisc]

I have a list of terms I want to add .com to the entire list.

They are all unique words, so no opportunity to use the "find and replace" tool.

Any quick tricks to do this automatically with excel? Thanks.

[bramiozo]

download notepad++,
copy column of names to notepad++, then do :
ctrl+h, activate regular expression under search mode.
find : ([^\s]+)\s*$
replace : \1.com

[gammascalper]

If the names are in column A, then in Column B type in =A1&".com"

Then copy and paste that all the way down.

[bwhhisc]

If the names are in column A, then in Column B type in =A1&".com"

Then copy and paste that all the way down.

Thanks, that works :)

And figured out how to "drag" the right bottom corner of the first cell all the way to bottom to add ".com" to the whole list.
Very nice trick, thanks!

[bramiozo]

...or you can do that :cool: .