In excel, extract a string of numbers within the middle of a string

In excel, extract a string of numbers within the middle of a string

Try this:

=--MID(A1,FIND(:,A1)-2,8)

Then format it as time.

With data in A1, in B1 enter:

=TRIM(MID(SUBSTITUTE($A1, ,REPT( ,999)),4*999-998,999))

enter

This assumes that your data is a set of sub-strings, separated by spaces, and that we want the 4th sub-string.

In excel, extract a string of numbers within the middle of a string

Leave a Reply

Your email address will not be published. Required fields are marked *