ToolsAutocorrect OptionsAutoformat as you type. Uncheck "internet and network
paths with hyperlinks" to disable the @ stupidity.

In C1 enter =A1 & B1

Double-click on fill handle of C1 and get instant copy down.

Select column C and Copy then EditPaste Special(in place)ValuesOKEsc

Delete A and B columns.


Gord Dibben MS Excel MVP


On Thu, 7 Feb 2008 09:43:03 -0800, Sam Evans <Sam
wrote:

I'm trying to merge two rows of cells in order to create an e-mail list. The
e-mail adress is the same for all but the prefix is different.

I am having some difficulty as '@' is stupidly a function symbol in Excel,
does anyone know a way around this?

Also, is there a way to 'CONCATENATE' the entire set of data so that in one
swift move A1+B1=C1, A2+B2=C2 etc. without having to concatenate each row.

Thanks.

Sam