View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
 
Posts: 1,231
Default 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).