Text string question

[redspanna]

Hi all

I have several different text 'strings' that populate column D of my sheet
for example

X3 SINGLE TTP DESL
X6 INT SVS TTP DESL ORG

is it possible to have a formula that will check each cell thru column D and only copy any letters upto the word "TTP"

so the result from above would read

X3 SINGLE
X6 INT SVS

many thanks

 

[VoG]

Try

=LEFT(D1,FIND("TTP ",D1)-2)

 

[redspanna]

Thank you

afer a little typo error on my behalf your formula worked !!

many thanks