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

On Aug 4, 4:05*pm, infinite1013
wrote:
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.