#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Real Dummy
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I change uppercase to proper case in entire worksheet? Karen Excel Worksheet Functions 7 October 21st 05 12:31 PM
CHANGE WHOLE EXCEL worksheet TO UPPERCASE LETTERS? mineralgirl Excel Discussion (Misc queries) 4 September 3rd 05 01:29 AM
How do I change certain cells to Uppercase TazDevil Excel Worksheet Functions 4 August 1st 05 06:35 AM
uppercase to lowercase Missy Excel Worksheet Functions 1 February 3rd 05 09:10 PM
uppercase to lowercase Mammoth Excel Discussion (Misc queries) 3 November 28th 04 03:19 AM


All times are GMT +1. The time now is 01:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"