Lowercase text changed by Ecel to Uppercase after import

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I opened a tab-separated list text file in Excel. One column had lowercase
text, which Excel converted to uppercase. Is there a way to control this.
Also how would I correct this in Excel

Thanks
John
 
Possibly AutoCorrect (Tools menu). Uncheck capitalize first letter in
sentence. Is it just the first letter in the column or every word?
 
The file I am opening is as follows with a tab separating the 'true' from the
name
Sam Smith true
Will Smith true
etc...

and it opens in Excel like this
Sam Smith TRUE
Will Smith TRUE

I tried the Autocorrect settings (thanks) but this did not help.

Any other ideas?
 
When you see the wizard, you can tell excel to treat that column as Text
(instead of General).
 
Ps. If you don't see the wizard, you can rename the text file to *.txt, then
use file|open.

You'll see the wizard then.
 
John

Excel sees the word "true" or "false" and thinks it is the result of a formula
so changes to Upper case.

No way to prevent that without pre-formatting as text or preceding with an
apostrophe.

See Dave's suggestion about the Text import Wizard.


Gord Dibben MS Excel MVP
 
Back
Top