LinkBack URL
About LinkBacks
ryanb4614 
Hello. My worksheet has ' in the names. Example: Annie's is showing as Annie€s how can I fix this? I tried replace but it says to long of a list.. And its not a comma its a apostrophe sorry for the title just noticed, type to fast before I think.
Hello. My worksheet has ' in the names. Example: Annie's is showing as Annie€s how can I fix this? I tried replace but it says to long of a list.. And its not a comma its a apostrophe sorry for the title just noticed, type to fast before I think.
Post a workbook.
Entia non sunt multiplicanda sine necessitate
See the workbook please. There is over 100 cells with these characters the more I look in it seems like its not just apostrophes... is it the ™ symbols like this setting this error?
hurm.... the file is originally a text file.... when i go to open it and change the file orgin to UTF8 everything is perfect. Its opening default on Windows ANSI in excel
Last edited by ryanb4614; 07-30-2010 at 09:19 PM.
Those are Unicode characters 20AC and 2122. Where are the coming from?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks