One suggestion would be to use Data/Text to Columns to separate the
numbers (choose Delimited/Space)

OTOH, why bother?

In article . net,
"Bob Smith" wrote:

Only problem is that I can't separate out the PB number pick if that number
is one Tried numerous variations of formulas, changing how the PB number
shows ect. I realize I should have dedicated a separate column for the PB #,
but it's too late now, with over 160 sets of numbers already typed in.

Any ideas on how to complete this formula? Or, is there a better argument to
use?