I have been given a list of customers in Excel format, where the Cell Comments functionality has been abused to store a myriad of additional information under the customer name, such as email addresses, alternative phone numbers, names of representatives, family members etc.
I have been able to get the comments exported into their own column, but now I am trying to find a way of extracting email addresses into the neighbouring column. For example, if the cell contains "Rep: [email protected], Mob: 2188437" I would like "[email protected]" to appear in the next column.
What would be the easiest way of achieving this?
Thanks!
Bookmarks