Extract specific words from a cell value and copy to new cell

[allanhoey]

hi please can someone help here i have multiple cells with no specific format and i would like to extract data beginning with TP then the following 9 values

Eg in cell A1

Example only TP66633hrr- position is random

i would like to end up with TP66633hrr- in cell A2

the TP could be anywhere in the string of data

is this possible with =IF</SPAN></SPAN>

 

[win_zip]

If case sensitive: MID(A1,FIND("TP",A1),11) otherwise MID(A1,SEARCH("TP",A1),11)

 

[allanhoey]

=MID

worked perfectly

Thanks