How to change The @ (at sign) in an Excel Sheet

[ExcelGlenn]

I have downloaded the 2021 Major League Baseball Schedule which was created in excel. I am changing some of the Team Names to correspond with my other Baseball Data Bases. When a team is playing away from home, the team they are playing against is shown as, for instance, @Ana. I want to change @ana to @Laa. However, the Find/Replace gives me an error because of the @ sign. Is there a way of changing these cells without creating a Module?? I am using Excel 2010.

 

[Rick Rothstein]

You could put an apostrophe (') in front of the @ sign in the "Replace with" field. That will signal to Excel to treat the entry as Text. The apostrophe will show in the Formula Bar if you select the cell but Excel will ignore it if you do any manipulations with the text in the cell.

Note: I am assuming your original values are in cells formatted as Text.

 

[ExcelGlenn]

Thanks for the quick reply.

I changed the Sheet from General to Text. I get the error - ""Excel cannot find the data you are searching for".
I used '@Ann in the Find field and tried both '@Laa and @Laa without the ' in the Replace field but still received the same error.

 

[Rick Rothstein]

Do you have tables on the sheet where @Laa and @Ann are referring to columns within that (those) tables? If not, how did you get those values into the cells without raising an error?

 

[ExcelGlenn]

Do you have tables on the sheet where @Laa and @Ann are referring to columns within that (those) tables? If not, how did you get those values into the cells without raising an error?

No Tables. The Spread Sheet came from a website with the @ signs already there. I just keyed in a blank cell - '@Laa and then copied it into one of the cells with @Ann in it and it worked. So maybe the answer is to write a VBA. What do you think??

 

[Rick Rothstein]

In that case, my gut tells me Excel thinks those cells are Hyperlinks. If you select one of them and right click it, do you get an item in the popup menu offering to remove the hyperlink?

 

[ExcelGlenn]

A right click shows me the word hyperlink at the bottom of a long list but not the option to remove it.