Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find Upper Case Text
I have searched the excel tips but can't find what I need, so maybe someone on the Forum can help me. I have a sheet with roughly 12,000 lines, in 2 of the columns I have text but the problem is, some of it is Proper Type and some of it is Upper Case. I need to be able to *identify* (not change) the Uppercase Text but remembering that the Propr Type has Cap at the begining. Is this possible to do? -- John1950 ------------------------------------------------------------------------ John1950's Profile: http://www.excelforum.com/member.php...o&userid=18671 View this thread: http://www.excelforum.com/showthread...hreadid=488145 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find Upper Case Text
For Each cel In ACtivesheet.UsedRange If cell.value = UCase(cel.Value) Then Msgbox cel.Address & " is Upper Case" End If Next cel -- HTH RP (remove nothere from the email address if mailing direct) "John1950" wrote in message ... I have searched the excel tips but can't find what I need, so maybe someone on the Forum can help me. I have a sheet with roughly 12,000 lines, in 2 of the columns I have text but the problem is, some of it is Proper Type and some of it is Upper Case. I need to be able to *identify* (not change) the Uppercase Text but remembering that the Propr Type has Cap at the begining. Is this possible to do? -- John1950 ------------------------------------------------------------------------ John1950's Profile: http://www.excelforum.com/member.php...o&userid=18671 View this thread: http://www.excelforum.com/showthread...hreadid=488145 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert numbers to text | Excel Discussion (Misc queries) | |||
Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
Convert Numeric into Text | Excel Worksheet Functions | |||
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) |