find text before specific text

[kisanvikas2015]

Hi,

I wanna find text before fixed text in cell D2.

File attached.

Regards,
Vikas

[humdingaling]

put formula in b2 and fill down

Please Login or Register  to view this content.

[ashishmehra2010]

Hi Vikas,

Try this =IFERROR(LEFT(A2,SEARCH($D$2,A2)-1),"")

Even if the data is case-sensitive; SEARCH function will take care of.

Cheers!

Regards,
AM

[Ali Kırksekiz]

For B2 cell

Please Login or Register  to view this content.

then pull down

[kisanvikas2015]

Thanks to all humdingaling, ashishmehra2010 & Ali Kırksekiz 3 of you

I got the solution.

Learnt the difference between SEARCH & FIND function. Thanks again.

Vikas

[ashishmehra2010]

Hi Vikas,

I am happy for you that you learn some thing new today.

Please take a moment & mark the thread as SOLVED.

Regards,
AM