Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
change lower letters to upper letters
In the Excel, how to change all sentense from lower letters to upper letter
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
change lower letters to upper letters
Winnie, you can use the upper function, with text in column, in another
column put =UPPER(A1) and copy down, you can then copy that column and paste special back over you data. Or you could use a macro like this Sub MAKE_ALL_CAPS() 'select your range and run this to change to all CAPS Dim cel As Range For Each cel In Intersect(Selection, _ ActiveSheet.UsedRange) cel.Formula = UCase$(cel.Formula) Next End Sub -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Winnie" wrote in message ... In the Excel, how to change all sentense from lower letters to upper letter |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
change lower letters to upper letters
=UPPER(range)
-- Brevity is the soul of wit. "Winnie" wrote: In the Excel, how to change all sentense from lower letters to upper letter |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change the header columes back to letters not numbers | New Users to Excel | |||
Change source text in Excel from all caps to upper and lower case. | Excel Discussion (Misc queries) | |||
changing lower case to upper case | Excel Discussion (Misc queries) | |||
change typed text to upper case | Excel Discussion (Misc queries) | |||
How do I change existing text from lower case to upper case | Excel Discussion (Misc queries) |