Does the @ character hold any functional significance in Excel? I can'
seem to enter any @text. It returns that the function is invalid.
came acrozz a file that already had cells with @text but I can't see
to use the find.replace function on those.
Help, please.
Thanks

--
Prosperin
-----------------------------------------------------------------------
Prosperina's Profile: http://www.excelforum.com/member.php...fo&userid=1452
View this thread: http://www.excelforum.com/showthread.php?threadid=26150

Prosperina

Lotus used the @ as a start for functions and Excel has it for
compatibility. If you precede with a single apostrophe (') all will be
well. (The apostrophe won't show)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(E-Mail Removed)HIS


"Prosperina" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> Does the @ character hold any functional significance in Excel? I can't
> seem to enter any @text. It returns that the function is invalid. I
> came acrozz a file that already had cells with @text but I can't seem
> to use the find.replace function on those.
> Help, please.
> Thanks.
>
>
> --
> Prosperina
> ------------------------------------------------------------------------
> Prosperina's Profile:
> http://www.excelforum.com/member.php...o&userid=14526
> View this thread: http://www.excelforum.com/showthread...hreadid=261502
>