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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sam Evans - 07 Feb 2008 17:43 GMT

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

Reply to this Message

Gary''s Student - 07 Feb 2008 17:50 GMT

The apostrophe will help you:

use
'@
rather than
@

Signature

Gary''s Student - gsnu200768

> 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.
[quoted text clipped - 8 lines]
>
> Sam

Reply to this Message

Ron Rosenfeld - 07 Feb 2008 17:59 GMT

>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

Reply to this Message

Gord Dibben - 07 Feb 2008 18:20 GMT

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

>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.
[quoted text clipped - 8 lines]
>
>Sam

Reply to this Message