Extracting AlphaNumeric data from Numeric data

**vyskcomm** · 06-30-2014, 06:10 PM

I have some strings of data that looks like this all in one column:

1400081193 2014-05-14 10:05:33 [email protected] 555.55.555.555

1400081194 2014-05-14 10:05:33 [email protected] 555.555.55.555

1400081195 2014-05-14 10:05:33 [email protected] 555.55.55.55

I am trying to create an email list that looks like this:

[email protected]

[email protected]

[email protected]

**Ace_XL** · 06-30-2014, 06:15 PM

Try

Data -- text to Columns -- Delimited by space -- ok

**vyskcomm** · 06-30-2014, 06:23 PM

Perfect, except now I feel like I wasted my day trying to figure it out on my own. Thanks!

**Tony Valko** · 06-30-2014, 06:43 PM

Here's a formula...

A1 = 1400081193 2014-05-14 10:05:33 [email protected] 555.55.555.555

=TRIM(RIGHT(SUBSTITUTE(LEFT(A1,FIND(" ",A1&" ",FIND("@",A1))-1)," ",
REPT(" ",LEN(A1))),LEN(A1)))