Change to all caps

**SIGMANU425** · 06-10-2009, 04:01 PM

How do I change my spreadsheet from all lower case word to all caps with out having to retype everything?

**martindwilson** · 06-10-2009, 04:05 PM

1 copy the lot into word change cas paste back
2. use a function to change cells then copy paste back
3. download an add in that will change case
4. use a macro to do the same.
what do you prefer?
heres a macro

Please Login or Register  to view this content.

**contaminated** · 06-10-2009, 04:10 PM

Try UPPER() function..

**SIGMANU425** · 06-10-2009, 04:14 PM

Originally Posted by contaminatedwitexcel

try upper() function..

how do i use the function or where is it located on excel?

**emanon132501** · 06-10-2009, 04:18 PM

Insert a blank sheet

then type =upper(*sheet name of your source*'A1) on cell A1
then copy cell A1 to all cells in the new sheet

**contaminated** · 06-10-2009, 04:30 PM

Go Insert>Function, and from drop down list of categoy field select "Text". Here u can find UPPER() function. Click "OK"
In the text field refer to the cells, and hit Enter. After, copy the formula down then accross as far as needed.

See attached book..