Home |
Search |
Today's Posts |
#1
|
|||
|
|||
lowercase to caps
How can I automatically change a column of lowercase text to caps?
|
#2
|
|||
|
|||
There are (at least) two ways to do this. One way is with a
formula. In a empty column next to your data, enter the formula =UPPER(A1) and copy down as far as you need to go. Then, copy this range, and do a Paste Special Values over the original data and delete the column containing the formulas. The second way is to use a VBA macro. Sub ToUpper() Dim Rng As Range On Error Resume Next For Each Rng In Range("A1:A100").SpecialCells( _ xlCellTypeConstants, xlTextValues) Rng.Value = UCase(Rng.Text) Next Rng End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "TL2000" wrote in message ... How can I automatically change a column of lowercase text to caps? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel sheet all caps and needs to be only the first letter caps.. | Excel Discussion (Misc queries) | |||
Changing text from all caps to first letter cap | Excel Discussion (Misc queries) | |||
Caps to lower case | Excel Discussion (Misc queries) | |||
uppercase to lowercase | Excel Discussion (Misc queries) | |||
Is there a way to have a function auto correct words in ALL CAPS . | Excel Worksheet Functions |