@ character

  • Thread starter Thread starter Prosperina
  • Start date Start date
P

Prosperina

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
 
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 address removed)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Square character(s) in cells 2
Special Text to Column question 3
Populate cell with multiple non-blank text values 3
where does a character appear in a cell? 4
2007 cell character limit 11
Conditional formatting 1
Text wrap spec 4
How can I display and print more than 1024 characters in a cell? 1

Back
Top