Capitalization?

E

everlong

Okay...i have a spreadsheet with about 10 thousand cells, that all need
the first letter capitalized. Am i screwed and have lots of work ahead
of me? or is there a simple way to do this?
 
J

Johnny Stranger

there is a text function called PROPER that you could use.

the function capitalizes the first letter in a text string and any other
letters in text that follow any character other than a letter. Converts all
other letters to lowercase letters.

check Excel help for more detailed instructions
 
J

JMB

you could enter a formula like this in a blank column next to your data (my
test data started in cell B1 and I entered this in cell A1)

=UPPER(LEFT(B1,1))&RIGHT(B1,LEN(B1)-1)

then copy it down as far as you need to. Next select your corrected data
and copy, select the first cell containing your old data, click Edit/Paste
Special/Values. Then delete the column containing the formula above.

Be sure to back up your data.
 
Top