Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I change lowercase data to capped data?
I have a bunch of data that I typed in lowercases in lots of cells. What can
I do to change the data to uppercase letters all at the same time? I don't want to have to retype the data. Thank you |
#2
|
|||
|
|||
How do I change lowercase data to capped data?
Hi,
With "abcd" in A1, enter "=UPPER(A1)" in B1 - no quotes. - to get "ABCD." -- Ken Hudson "Monique" wrote: I have a bunch of data that I typed in lowercases in lots of cells. What can I do to change the data to uppercase letters all at the same time? I don't want to have to retype the data. Thank you |
#3
|
|||
|
|||
How do I change lowercase data to capped data?
If you want to do it all in place without using the UPPER formula then
select the cells you want to change and run this macro: Sub UpperCase() Dim r As Range For Each r In Selection If Not r.HasFormula Then r.Value = UCase(r.Value) Next r End Sub Hope this helps Rowan Monique wrote: I have a bunch of data that I typed in lowercases in lots of cells. What can I do to change the data to uppercase letters all at the same time? I don't want to have to retype the data. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
monitor cell that uses data validation list for change | Excel Discussion (Misc queries) | |||
When I change my data, my formulas don't update the answers,why? | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
VBA to change size of data labels? | Charts and Charting in Excel | |||
How do I change a cell so I can have the data it contains in seve. | Excel Discussion (Misc queries) |