ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Text File Question (https://www.excelbanter.com/excel-worksheet-functions/232113-text-file-question.html)

UGScott

Text File Question
 
Why does this •¦ replace the first e in the word Creme in Excel

Sheeloo

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


Jacob Skaria

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


Ron Rosenfeld

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

Stephen Bye[_2_]

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.



Harlan Grove[_2_]

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).



All times are GMT +1. The time now is 07:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com