Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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: h: 01187 475 454

Is there any easy way to do this?


share|improve this question

If its a one off, just use Find/Replace in two steps

Replace M:* e:  with nothing (note the space on the end)
Replace  h: * with nothing (note the leading space)

share|improve this answer


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...

share|improve this answer


  • The A column contains the data (otherwise change the references in the below formula)
  • All cells in question contain the text e: before and h: after the e-mail


  • In a new column, create a formula that extracts the e-mail
  • If warranted, copy/paste the new column using Paste Values and remove the original columns


=MID(A1;FIND("e: ";A1)+3;FIND("h: ";A1)-FIND("e: ";A1)-4

MID retrieves a substring of the original cell using a start index and a specified number of characters. FIND is used to get the index of the e: and h: markers.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.