Is it possible to stop Excel thinking @ is a function?

[Sam Evans]

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

 

[Gary''s Student]

The apostrophe will help you:

use
'@
rather than
@

 

[Ron Rosenfeld]

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

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,

That behavior is inherited from Lotus

does anyone know a way around this?

what formula are you using? It's difficult to understand why you are having a
problem. If only the prefix is different, then something like:

=prefix & "@." & email_address

should work fine.

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.

The "+" is the addition operator. The "&" is the concatenation operator.

So if you want to concatenate, and not add:

C1: =A1&B1

Then select C1 and fill down as far as required. The cell references will
adjust.
--ron

 

[Gord Dibben]

Tools>Autocorrect Options>Autoformat 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 Edit>Paste Special(in place)>Values>OK>Esc

Delete A and B columns.


Gord Dibben MS Excel MVP


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