Excel how to find substring match, then extract numbers in the string.
Posted on 2014-12-16
I have some complicated two step process need to be done in my work. I have two tables, one for email address and another for email header information. If there's email address match, then I extract IP address from the header information.
asdfasdfasdfadsf email@example.com sadfasfdsafa 111.222.333.444 asdfasdf asdf asdf
asdfasdf firstname.lastname@example.org 3223sadadsf sadfas32423 444.222.555.777 2432423113sadfadfasdfads
Both table has only one column.
Now the returned values should be 1111.222.333.444 and 444.222.555.777. Then either insert the two IP addresses to 2nd column of Table A or B or open with a new table.
How can I do that?