SOLVED

Extracting specific text/number combo

Copper Contributor

I am trying to pull out specific information from a list of cells that do not always have the same amount of characters surrounding the information, but always has the same of amount of characters to pull out and same format. Two examples below and the information I need to pull out is in bold.

 

MCHLATTUDETOUR 285/45R19 107V

UNR TIGERPAWTR P185/60R15 84T

 

What formula would I use?

4 Replies

@Jenna_Foy That could be 

=MID(A1,FIND("/",A1)-3,9)

 

where A1 would contain the string you want to extract the 9 characters from.

Screenshot 2022-04-07 at 21.13.19.png

@Jenna_Foy 

With such a text in A2 and down, enter the following formula in B2, then fill down:

 

=MID(A2,FIND("/",A2)-3,9)

best response confirmed by Grahmfs13 (Microsoft)
Solution

@Jenna_Foy 

 

=MID(C4,SEARCH("???/??R??",C4),9)

 

Maybe with this formula. However there is a weak spot as you can see in the attached file if you compare the last 2 examples. 

@OliverScheurich 

This is exactly what I needed, thank you!!

1 best response

Accepted Solutions
best response confirmed by Grahmfs13 (Microsoft)
Solution

@Jenna_Foy 

 

=MID(C4,SEARCH("???/??R??",C4),9)

 

Maybe with this formula. However there is a weak spot as you can see in the attached file if you compare the last 2 examples. 

View solution in original post