View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SherryScrapDog SherryScrapDog is offline
external usenet poster
 
Posts: 16
Default Extract name before comma, space & number

I have a column of names that also have page number(s). Here are some
examples:
Mary, 155
Joe, Rev., 60
Mark, Mrs., 115, 120, 130

There could be many page numbers.
I have a working formula for getting the page numbers into a separate
column. I can't find one that gets the Joe, Rev. (for example); I only get
Joe.

Can you help? Thanks if you can!! Sherry