Chg existing cells fr Proper to Upper w/o re-typing.

G

Guest

I have several workbooks that have several worksheets that need a particular
group of cells to be in Upper Case. These cells are currently occupied with
proper case words. Can I change them to Upper case without having to retype
all the information in these cells? If so, how?
 
B

Bob Umlas

in a parallel range, enter =UPPER(A1) (or wherever the data is) & fill down'
Copy the result, paste/special values onto the original; remove the
formulas.
Bob Umlas
Excel MVP
 
S

SteveG

You can use the UPPER function.

=UPPER(A1) where your text is in A1. Copy down as needed.


HTH

Stev
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto-fill information while typing 14
How do I change uppercase to proper case in entire worksheet? 7
Still trying to average 4 worksheets and having formula problems 3
Excel 2003 Freezes when copy/paste cells into different workbooks/ 1
General Cell Format changed to Date for all Cells 1
Paste to next row if cells are not empty 2
Can't copy cells to new workbook 1
All words and Symbols of keybord should be added to Auto Shapes 1

Top