Sorting Column Data

**Mike74** · 03-08-2010, 03:55 PM

Hey all...I have a weird column of data a pdf converter gave me.

A1 Phone #
A2 Name
A3 phone#
A4 Name
so on

I was trying to get the name next to the phone number. Is an if statement the best? If(A2=number, "", A2)? And how do you tell excel if A2 = number? Also keep in mind that on each phone number row, there is other data. For example b1 has minutes used, c1 charges, etc... I just thought I could insert a column and put an if statement in.

Thanks for your help!

**zbor** · 03-08-2010, 03:58 PM

Try ISNUMBER function

**Mike74** · 03-08-2010, 04:11 PM

I tried it...and it works....only problem now is that 333-333-3333 doesn't count as a number? When I put just 3 in, the formula works.....ugh...frustrating

**zbor** · 03-08-2010, 04:19 PM

Can you upload example?

You can change your relevant data but keep formating.
Espetially for telephone numbers:

111-111-11
or
111111111
and other forms that might appear

**Mike74** · 03-08-2010, 04:29 PM

Here you go...thanks for your help!

**Mike74** · 03-08-2010, 04:37 PM

I think I'm going to try it another way.....just delete every other row and be done with it.

**zbor** · 03-08-2010, 04:41 PM

Here, try this in B2 and pull down

=IF(AND(LEN(A2)-LEN(SUBSTITUTE(A2,"-",""))=2,ISNUMBER(--(SUBSTITUTE(A2,"-","")))),A3,"")

Then you can add filter and filter out blanks: