![]() |
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 |
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 |
All times are GMT +1. The time now is 07:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com