Cutting a figure out of a string of text.

  • Thread starter Thread starter infinite1013
  • Start date Start date
I

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.
 
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
 
Back
Top