Name Extract

Dear Excel Guru's,

Hope all are doing well. what i'm trying to do is to extract customer name for example if customer have same name i.e., filtra consultant engineering i want to extract as filtra and R.V. Associate or R V Associate extract to RV Associate.

Attached file for your reference and thanks in advance

Try this in D2 and copy down.

Please Login or Register  to view this content.

Dear Excel Guru,

Thank you so much for your quick response to my query its work fine.

You are welcome.