Hi, welcome and thank you for your question. My name is ***** ***** I am glad to assist you today.
I am very sorry about your issues. Can you send me a sample of your Excel data so that I can directly check the best formula to fit your needs? You can attach the Excel file here when you reply using the paper clip icon.
Please let me know by replying to me here so that I can help you further.
Thank you for sample Excel file. Please give me a moment to check this file for you.
Ok, so you got the data from an email message's TO or FROM field? Please give me a moment to check if this can be converted by Excel or if it needs to be extracted manually.
I will keep you posted.
Yeah, I am working on the excel file. I was able to isolate the data but few manual cleanup touches are required since the result is a single row only. Please give me a moment, I am working on this now.
Ok I am working on it now.
Thank you for patiently waiting.
Here is the completed file:
I hope that helped.Please remember to rate my service positively (3-5 stars/faces) if this helped. Tips are always highly appreciated!
If you need further assistance, please do not rate me negatively with 1 or 2 faces. Instead, please reply to me so that I can help you further.