Extract Name from exact format

[KIM Chanthan]

Hi,

Anyone has way to extract name from this format?
Ex:
Cash Out Refinance Client Kim Chanthan (DB.001717)
Result: Kim Chanthan

Thanks,

 

[azumi]

Just for your example, consider your text on cell A1

=LEFT(TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",90)),270)),(FIND("|",SUBSTITUTE(TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",90)),270))," ","|",2)))-1)

 

[vletm]

KIM Chanthan
Is 'result' always between texts "Client" and "(DB." ?

 

[bosco_yip]

Maybe,

=MID(A1,SEARCH("client",A1)+7,FIND("(",A1)-SEARCH("client",A1)-8)

or,

=TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",30)),120,90))

Regards
Bosco

 

[KIM Chanthan]

Just for your example, consider your text on cell A1

=LEFT(TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",90)),270)),(FIND("|",SUBSTITUTE(TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",90)),270))," ","|",2)))-1)

It works perfectly. Thanks

 

[KIM Chanthan]

Maybe,

=MID(A1,SEARCH("client",A1)+7,FIND("(",A1)-SEARCH("client",A1)-8)

or,

=TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",30)),120,90))

Regards
Bosco

It works perfectly. I can understand about this formula. Thank

 

[KIM Chanthan]

KIM Chanthan
Is 'result' always between texts "Client" and "(DB." ?

Yes