View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
april april is offline
external usenet poster
 
Posts: 111
Default 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