text with leading @ symbol - that function is not valid

[ljon]

Hi, I am trying to put twitter handles in a cell. ie. @blah.

When I enter @blah into a cell, excel responds with
That function is not valid

How do I prepare/format a call to allow it to contain text with a leading @ symbol?

 

[pedie]

try
'@blah

 

[ljon]

Yep, that works.

There must be a way to do it without the leading ' though - because I've run across another spreadsheet with cells containing @blah. I just don't know how to reproduce it.

 

[pedie]

There could be way that i dont know

 

[pgc01]

Hi ljon
Welcome to the board

Try formatting the cell as text before entering the string.

 

[ljon]

D'oh! Formatting the cell as text before entering @blah does the trick.

Thanks!