| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find the upper case letters within a cell
i have a cell that is a journal reference. here is an example US POSTMASTER
--1025093-1-July Intl Renewal- Perm. the upper case letters refer to the vendor. i want to extract only the vendor name from the cell. can't use find conventions such as find the "--" as the two dashes are not always part of the cell. thanks in advance for your help -- aprilshowers |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| upper case letters | Excel Worksheet Functions | |||
| Upper Case Letters | Excel Discussion (Misc queries) | |||
| Renaming Sheet Tab to Upper Case Letters | Excel Discussion (Misc queries) | |||
| need to make empty cell to type upper case letters | New Users to Excel | |||
| Formatting Upper Case letters | Excel Worksheet Functions | |||
Threaded Mode
