Need to remove Date from Strings in Excel

[dibyesh]

Hello All,

I have data in following format:

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'; color: #000000}</style>shrestha.prakhar77@gmail.com2017-07-31 05:08:37

I need to remove data & time. I need email address only.

How do I do this?

Thank you in advance.

Regards,

Dibyesh Giri

 

[ajamess]

If all dates are in that format. (YYYY-MM-DD HH:MM:SS) below will work. I'm assuming that data shown above is in "A2", if that isn't the case adjust formula accordingly:

=left(a2,len(a2)-19)

 

[drognanar]

Does it always end with .com? You can use LEFT(A1,FIND(".com",A1)+3) to get email.

 

[dibyesh]

Thank you so much! it worked.