(Mod: if this is not the appropriate area for this post, please move. Thanks.)
I am attempting to Find and Replace text in an Excel 2016 spreadsheet.
For example, I'm searching for the following URL in the spreadsheet:
Upon located this URL in the spreadsheet, I want to replace the following with the @ symbol:
The result would be this:
Previously, I was using Excel online and was able to do this easily. I'm now using a desktop version which is giving me the following error message: "This function is invalid"
When I attempt to make the change manually, it seems to initiate a function; I am not familiar with Excel functions and do not need this at this time.
I've read online that the @ symbol is reserved and related to functions (?) and therefore cannot be used as a simple text symbol-- is this true?
Is there any method (or work-around) to achieve this?
Thank you in advance.