filter emails from doc with mixed info

try the following:

in the column that contains the mixed info:

assuming that e-mail addresses cannot contain blanks so

1) find the first space in the string contained in the cell
2) make a substring up to the character before that space
3) make a substring of the rest. trim it.

from #2 you get the e-mail
from #3 you get the phone number

Many thanks...I'm afraid I'm too much of a beginner to understand what you mean by making strings and substrings....do you think you could explain this for a total dummy? sorry...many thanks!

OK
for each row with data in a blank column insert the following:

assume that column D has the mixed info.

=iferror(find(" ",d2),0)

in the very next column for the same row:

=if(iferror(find(" ",d2),0)>1 ,left(d2,iferror(find(" ",d2),0)-1),d2) that's the email address
it looks complicated because I inserted some error profing for the cases that there is no phone number

in the very next column for the same row:

=if(iferror(find(" ",d2),0)>1 ,mid(d2,iferror(find(" ",d2),0)+1,60)," No phone number") that's the phone number

thank you...I really tried, but I haven't got a clue what you're talking about...I'm afraid I'm looking for basic answers in terms of 'click' on this option, 'then select that' etc....then I might be able to understand...really appreciate you having tried nevertheless...sorry

are the blank spaces have a fixed width? If they have fixed width, you can use text to column function..


--------------------------------------------------------------------------------------------
Visit me!

send me a couple of entries I''ll program them and all you need to do is copy the formulas down to the rest...

Thank you, very kind of you. Actually, I kept trying things last night and found that I could use the 'find' option and if I put @ in there...it selected all the e-mail addresses, which I then selected in the 'find' results and copy-pasted...phew...that did the trick for now. For some next time though..the sort of formula you're saying....where would I be supposed to put it? I've never programmed any formulas in Excel, so this may be obvious to you...but I ignorantly tried pasting them into the actual cells, which obviously had no result whatsoever...
Many thanks again though for your help and kind offer!
Same to the others!
Best Regards.

Send me a few lines of data and i'll show you exactly how is it done.

Thank you, I've uploaded a sample with fake data. I hope it's accessible to you like that.
many thanks again.