Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Uppercase
I have no idea what I am doing and only hope someone can help. I am trying to change lowercase to uppercase AND the formulas I see are a foreign language to me. I had labels in Word and in order to update the label list I decided to shift the labels to excel, but all of a sudden it started to convert my uppercase to lowercase and I can't make it stop. I really don't want to type all of the names again. Help, I remian a Real Dummy Thanks in advance. -- Real Dummy Posted from - http://www.officehelp.in |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Uppercase
Let's assume your names are in column A.
Insert a column next to A by right-clicking on column B and choosing Insert. In B1, type =UPPER(A1) This should display your name entirely in upper case. Copy this formula down the entire column (click on the small square box in the bottom right hand corner, and drag it down to the bottom of your column). You should now have all your names in upper case. -- Regards, Fred "Real Dummy" wrote in message ... I have no idea what I am doing and only hope someone can help. I am trying to change lowercase to uppercase AND the formulas I see are a foreign language to me. I had labels in Word and in order to update the label list I decided to shift the labels to excel, but all of a sudden it started to convert my uppercase to lowercase and I can't make it stop. I really don't want to type all of the names again. Help, I remian a Real Dummy Thanks in advance. -- Real Dummy Posted from - http://www.officehelp.in |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change uppercase to proper case in entire worksheet? | Excel Worksheet Functions | |||
CHANGE WHOLE EXCEL worksheet TO UPPERCASE LETTERS? | Excel Discussion (Misc queries) | |||
How do I change certain cells to Uppercase | Excel Worksheet Functions | |||
uppercase to lowercase | Excel Worksheet Functions | |||
uppercase to lowercase | Excel Discussion (Misc queries) |