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.

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.