Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text File Question
Why does this •¦ replace the first e in the word Creme in Excel
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text File Question
This is what I got
crème may not show correctly... creme must be defined for autocorrection... look in Tools-AutoCorrect Options Scroll down (or type in REPLACE box) the list at the bottom to find Creme If you don't want this change then remove Creme from the list "UGScott" wrote: Why does this •¦ replace the first e in the word Creme in Excel |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text File Question
Check
ToolsAutoCorrect in 2003 Excep OptionsProofingAutoCorrect options in 2007 If this post helps click Yes --------------- Jacob Skaria "UGScott" wrote: Why does this •¦ replace the first e in the word Creme in Excel |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text File Question
On Wed, 27 May 2009 09:33:02 -0700, UGScott
wrote: Why does this ? replace the first e in the word Creme in Excel Do you perhaps, mean: crème where the e is showing an accent above it? Check your auto-correct options for creme -- crème --ron |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text File Question
"UGScott" wrote in message
... Why does this ? replace the first e in the word Creme in Excel Probably because in the Text Import Wizard, you didn't specify the correct code page. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text File Question
"Stephen Bye" wrote...
"UGScott" wrote in message Why does this ? replace the first e in the word Creme in Excel Probably because in the Text Import Wizard, you didn't specify the correct code page. Correct diagnosis, but potentially misleading. The drop-down box in question in the Step 1 dialog for the Text Import Wizard is labeled File origin rather than code page. OP seems to have this set to OEM United States when it should be set to Windows (ANSI). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to tell number of spaces between values in saved text file fromthe original xls file | Excel Discussion (Misc queries) | |||
How do you save an excel file to be read as IBM-type text file ? | Excel Worksheet Functions | |||
Would Like to Automate Batch File Creation and Text FIle Import | Excel Discussion (Misc queries) | |||
How can I save a file as a comma-delimited text file in Excel? | Excel Discussion (Misc queries) | |||
Export excel file to semicolon delimited text file | Excel Discussion (Misc queries) |