Replacing Part of a Cell Two Part Question

[nscarletina]

Hi Guys,
Well I am back on the boards. Joy! No really- I love all the help I get here- but I hate not knowing what I am doing!

Ok- so here are my dilema's.

Numero Uno~
I have a cell that reads like this
217-428-3529 2174283529 Unspecified Error 13:28:28 0
I need this cell to read only the phone number
217-428-3529

That is going to be the easy part- I know. I tried to use the formula =MID(A1,FIND(",",A1)+2,2) but that doesn't work- I keep getting a #Value error. If someone could point me in the right way I would really appreciate it.

My second problem is just as easy I bet- I just don't know where to start. I have two lists- each of them will have phone numbers on them in the same format of 111-111-1111 for example. If there is a number on list (tab) 2- I want that number to be deleted from list 1. Does that make sense? This is of course all in the same workbook.

Ok- well if those are the worst things to happen to me today- I will be thrilled.

Thanks in advance for everyone's responses. You guys are the absolute best!

 

[Jonmo1]

1.

=LEFT(A1,12)

2.

On list 1 use a helper column to mark numbers that exist in list 1.

like
if Sheet1 is List1 (in column A)
In B1 put formula
=countif(sheet2!A:A,a1)

if any row in column B has a number > 0, then that number exists in the list2. You can use autofilter on column B for > 0 and delete.