Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello,
We prepare Excel spreadsheets for our IT team, who posts the data on the web using an Oracle server. They load them into searchable databases. The majority of apostrophe's look fine on the web. However, from time to time, an apostrophe will show up as an upside down question mark. All the apostrophe's look the same in the spreadsheet. I suspect that this is a character that MS Word generates. (The text often originates in Word). Is there a way to avoiding this? Like saving the text in notepad before copying it to the spreadsheets? As we're working with a third party, we're presently unable to troubleshoot as we'd like. Thanks in advance, Ellen |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You may want to type the subject "smart quotes" into Word help, and see
whether that does the trick. -- David Biddulph "EllenM" wrote in message ... Hello, We prepare Excel spreadsheets for our IT team, who posts the data on the web using an Oracle server. They load them into searchable databases. The majority of apostrophe's look fine on the web. However, from time to time, an apostrophe will show up as an upside down question mark. All the apostrophe's look the same in the spreadsheet. I suspect that this is a character that MS Word generates. (The text often originates in Word). Is there a way to avoiding this? Like saving the text in notepad before copying it to the spreadsheets? As we're working with a third party, we're presently unable to troubleshoot as we'd like. Thanks in advance, Ellen |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks so much, David. We wouldn't know for a while if that's what we need
as it's a process interacting with the IT team, but your suggestion sounds wonderful. Ellen :-) |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks, David. Ever since we turned the "smart quotes" off, the upside down
question mark disappeared. Ellen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Little question marks on page pop up note about AIM4WIN.XLA | Excel Discussion (Misc queries) | |||
to get the relative marks from a table of names,subjects & marks? | Excel Worksheet Functions | |||
Counting "Question Marks" | Excel Worksheet Functions | |||
Finding and deleting question marks | Excel Discussion (Misc queries) | |||
How to convert numbers with apostrophe's (ex. 219'2) to decimals? | Excel Worksheet Functions |