I am working with a worksheet that has a column of program
numbers. Some cells contain a single number; others
contain a start and end number. In between, there may be
many rows that don't have any valid data at all:
I need to ignore all cells that don't start with "ja",
then split this information into two separate columns as
I have figured out how to combine the FIND and MID
functions to identify the Begin and End program numbers.
My problem is that the method I'm using only allows me to
grab a fixed number of characters:
Is there a method I can use to grab the WHOLE WORD that
contains the "ja" at the beginning?
Thanks for any help you can give me.