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?
--
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

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

When you see the wizard, you can tell excel to treat that column as Text
(instead of General).



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

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

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

On Tue, 25 Apr 2006 13:49:02 -0700, 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