Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to find the best way to create an excel file which will be using
special characters like what you see for pronunciation in a dictionary like long and short vowels. I will need to export this to a tab delemented TXT file for InDesign to import. We have basically been using the Insert Character in Excel to pick the correct special characters but they come in all different fonts and do not work for exporting. Just gives my TXT file a bunch of "?". This is something new with me and I might have the lingo incorrect so any ideas of how to go about this would be helpful. I think basically I just need to know which font to choose in Excel that supports special characters that can be seen in a basic Notepad TXT file. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Excel must be exporting the special characters correctly. The text editor you
use does not support special characters. Try to import the text file in MS Word and see whether you get the right characters... TXT files are typically designed to support characters upto ASCII 128 and special characters have codes higher than 128. "Greg" wrote: I am trying to find the best way to create an excel file which will be using special characters like what you see for pronunciation in a dictionary like long and short vowels. I will need to export this to a tab delemented TXT file for InDesign to import. We have basically been using the Insert Character in Excel to pick the correct special characters but they come in all different fonts and do not work for exporting. Just gives my TXT file a bunch of "?". This is something new with me and I might have the lingo incorrect so any ideas of how to go about this would be helpful. I think basically I just need to know which font to choose in Excel that supports special characters that can be seen in a basic Notepad TXT file. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
nope, even when opened in Word or even back in Excel, they open with ????
instead of the proper characters. "Sheeloo" wrote: Excel must be exporting the special characters correctly. The text editor you use does not support special characters. Try to import the text file in MS Word and see whether you get the right characters... TXT files are typically designed to support characters upto ASCII 128 and special characters have codes higher than 128. "Greg" wrote: I am trying to find the best way to create an excel file which will be using special characters like what you see for pronunciation in a dictionary like long and short vowels. I will need to export this to a tab delemented TXT file for InDesign to import. We have basically been using the Insert Character in Excel to pick the correct special characters but they come in all different fonts and do not work for exporting. Just gives my TXT file a bunch of "?". This is something new with me and I might have the lingo incorrect so any ideas of how to go about this would be helpful. I think basically I just need to know which font to choose in Excel that supports special characters that can be seen in a basic Notepad TXT file. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how can I use paste special as TEXT and unicode | Excel Discussion (Misc queries) | |||
Unicode Sorting of Greek Words (Gentium Font) | New Users to Excel | |||
Can I create a special character for the Character Map? | Excel Discussion (Misc queries) | |||
Can I use Excel to convert Chinese character into Unicode? | Excel Discussion (Misc queries) | |||
Insert a standard character in a cell of excel. | Excel Worksheet Functions |