| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding words with capital letters and numbers in them
I have an excel sheet with strings in the cells in column C. In the
corresponding cell in column D, I want words of the type "TKCDT" or "TKR25" or "02587" or "25YHT" ie words having capital letters and/or numbers to be displayed. It does not matter whether this is accomplished using a fucnction or vba. Thanks in advance for all the help. Rajendra |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing grey column headings from numbers back to capital letters | Excel Discussion (Misc queries) | |||
| how to change small letters to capital letters | Excel Discussion (Misc queries) | |||
| how do i turn all letters into capital letters? | Excel Discussion (Misc queries) | |||
| Finding most common occurence of values in cells containing letters and numbers | Excel Worksheet Functions | |||
| Finding Numbers with Cells that also contain letters | Excel Discussion (Misc queries) | |||
![Raj[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
