software

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

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

quot;everlongquot; wrote:

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

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))amp;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.quot;everlongquot; wrote:

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