Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
uppercase
is there a way to convert all data in a range to uppercase and also
make it so all future entries are in uppercase? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
uppercase
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 -- Ken Hudson " wrote: is there a way to convert all data in a range to uppercase and also make it so all future entries are in uppercase? |
#3
|
|||
|
|||
Quote:
http://cpearson.com/excel/ChangingCase.aspx all the best
__________________
Thanks Bala |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing uppercase to lowercase | Excel Discussion (Misc queries) | |||
How to format cells for uppercase entry | New Users to Excel | |||
Uppercase | Excel Worksheet Functions | |||
How do I do a global change from uppercase to lowercase? | Excel Discussion (Misc queries) | |||
how to force uppercase | Excel Discussion (Misc queries) |