The text string is always different (ie, it does not always have a space and
6 characters after the number)....

Any other suggestions?

--
iperlovsky


"CLR" wrote:

If you always have a space and 6 characters after the number you seek, then...

=LEFT(RIGHT(A1,9),1)*1

Vaya con Dios,
Chuck, CABGx3



"IPerlovsky" wrote:

How would I extract a number (or series of numbers) using a single cell
formula from an alphanumeric text string that also contains spaces? One key
component of the number(s) in question, is that they have a space on either
side. See the example of the text string below:

"A 544646-BA CALIF UN1MM+ 5 7/1/2017 FSA 108.579 3.90 3.82 8 Aaa AAA"

In this example, I am trying to extract the number "8". However, there is
also the number "5", which appears first, and that I want to avoid
extracting. Additionally, the formula should be able to extract any number,
not specific to "8" or "5". This formula should always skip the first single
number surrounded by spaces ("5" in this example) and extract the second
number(s) ("8" in this example).

--
iperlovsky