Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Capitalization?
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Capitalization?
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 "everlong" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Capitalization?
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. "everlong" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Capitalization | Excel Discussion (Misc queries) | |||
Correct Text Case to PROPER capitalization | Excel Worksheet Functions |