Text Cleaning

I have an e-mail data. I need to fetch the name of the clients. For example in second row I want "abdulla". Attach excel sheet. Most of it start from dear but some are also starting from hi or some are starting from just name. any suggestions how i can get the name for these clients. if i am able to bring 80% of client name from the column I am happy.

Please help me.

look for a pattern. also, see here for regEx:

https://www.automateexcel.com/vba/regex/

https://stackoverflow.com/questions/...cell-and-loops

if that is too complex, you can always use string functions in VBA if there is any pattern whatsoever to data in each row. for instance, in row 1 you can do this:

Please Login or Register  to view this content.

that will find what you want in row 2:

Please Login or Register  to view this content.

if you want to do it without code and by formulas, you'll have to use find() and mid(), instead of mid and instr

https://docs.microsoft.com/en-us/off...p/mid-function

https://docs.microsoft.com/en-us/off...instr-function

https://support.microsoft.com/en-us/...3-d0d89b0a0628