uppercase

I

ifoundgoldbug

is there a way to convert all data in a range to uppercase and also
make it so all future entries are in uppercase?
 
G

Guest

Hi,

Assume that data is in column A and column B is empty. To convert existing
data in the range A1 to A5, in B1 enter =UPPER(A1). Copy this formula down to
B5. Highlight column B, right click and select Copy. Then right click again
and select Paste Special... > Values. You can then dlete column A.

To change data to upper case as you enter it, take a look at Chip Pearson's
page:
http://cpearson.com/excel/case.htm
 

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

Split cell based on uppercase letter 2
Auto Uppercase 5
uppercase to lowercase 4
uppercase 4
Convert to uppercase 1
Search for lowercase followed by uppercase and insert paragraph 3
Macro not working in 2007 4
Searching Uppercase characters 1

Top