I want to remove data from multiple cells in a spreadsheet using Excel 2010, so I only have the email address left.
They are in the current format:
M: 04545 545 545 e: email@example.com h: 01187 475 454
Is there any easy way to do this?
If its a one off, just use Find/Replace in two steps
You don't have space in any of email id(I doubt you will.)
Use a feature called text to columns in data tab excel(2007/10).
Use "Space" as custom delimiter.(It is pretty self-explanatory and shows you a preview as well).
That will get all the email addresses in single call and rest of the data in other columns. Then just delete the un-needed columns...