Extract name before comma, space & number

  • Thread starter Thread starter SherryScrapDog
  • Start date Start date
S

SherryScrapDog

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
 
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
Click to expand...

*IF* every name is followed by <comma><space><digit>, and IF there are NO
digits in the name, then:

=LEFT(A1,MIN(SEARCH({1,2,3,4,5,6,7,8,9,0},A1&{1,2,3,4,5,6,7,8,9,0}))-3)

If the variations in your column is more complex, then post back with more
information.
--ron
 
Thanks Ron!! Perfect! I keep trying to understand these by reading all of
the various other posts and just couldn't quite do it.
Much appreciation, Sherry
 
Thanks Ron!! Perfect! I keep trying to understand these by reading all of
the various other posts and just couldn't quite do it.
Much appreciation, Sherry
Click to expand...

Glad to help. Thanks for the feedback.

And reading and trying to understand how the various suggestions work is how
I've advanced my knowledge -- sometimes painfully slowly.
--ron
 
Back
Top