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 wrote:

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?

"Rae Drysdale" wrote:

Possibly AutoCorrect (Tools menu). Uncheck capitalize first letter in
sentence. Is it just the first letter in the column or every word?
--
Rae Drysdale


"John" wrote:

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

--

Dave Peterson