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

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

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

The apostrophe will help you:

use
'@
rather than
@


--
Gary''s Student - gsnu200768


"Sam Evans" 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

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

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,

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

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

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