Cutting a figure out of a string of text.

[infinite1013]

If I have a string of text in this format, AS&D DF ZS017 46336, is there a
formula that will allow me to cut out only the S017? This is the only figure
that I need out of the string and have about 16,000 cells that require the
needed formula. Thanks.

 

[Pete_UK]

Will you always have the same number of characters to the left of the
string that you want to extract? If so, then you can use this:

=MID(A1,10,4)

with your code in A1. Copy down as required.

Hope this helps.

Pete