Separate Phone Numbers

[realdallas1]

have excel sheet that has 3 columns of numbers and 3 columns of number types. i need to eliminate the landlines and keep the mobiles. do you have any suggestions on hoe to do this? any help is appreciated.

First Name	Last Name	Property City	Property State	Property Address	Phone 1	Phone 2	Phone 3	Phone 1 TYPE	Phone 2 TYPE	Phone 3 TYPE
abc	abc	abc	abc	abc	Landline	Landline	Mobile
abc	abc	abc	abc	abc	Mobile	Mobile
abc	abc	abc	abc	abc	Mobile	Mobile	Landline
abc	abc	abc	abc	abc	Landline	Landline	Landline
abc	abc	abc	abc	abc	Landline	Landline	Landline
abc	abc	abc	abc	abc	Mobile	Landline	Mobile
abc	abc	abc	abc	abc	Mobile	Landline	Mobile
abc	abc	abc	abc	abc	Landline	Landline	Landline
abc	abc	abc	abc	abc	Mobile	Mobile	Mobile

[td]

1​

[/td]​

[td]

2​

[/td]​

[td]

3​

[/td]​

[td]

1​

[/td]​

[td]

2​

[/td]​

[td]

1​

[/td]​

[td]

2​

[/td]​

[td]

3​

[/td]​

[td]

1​

[/td]​

[td]

2​

[/td]​

[td]

3​

[/td]​

[td]

1​

[/td]​

[td]

2​

[/td]​

[td]

3​

[/td]​

[td]

1​

[/td]​

[td]

2​

[/td]​

[td]

3​

[/td]​

[td]

1​

[/td]​

[td]

2​

[/td]​

[td]

3​

[/td]​

[td]

1​

[/td]​

[td]

2​

[/td]​

[td]

3​

[/td]​

[td]

1​

[/td]​

[td]

2​

[/td]​

[td]

3​

[/td]​

 

[myall_blues]

What do you mean by 'eliminate' landlines?
Do you mean you want to clear the contents of the corresponding cell if the type is LANDLINE e.g. clear Phone1 if Phone1 TYPE = Landline.
Or perhaps you want to delete the entire row?

If you just want to clear the contents the simplest would be to use a formula adjacent to your table as shown below, then copy the formula range and paste values over the top of the numbers. So in the example below, copy the range M2:O10 and then Paste Special->Values to F2.

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	First Name	Last Name	Property City	Property State	Property Address	Phone 1	Phone 2	Phone 3	Phone 1 TYPE	Phone 2 TYPE	Phone 3 TYPE
2	abc	abc	abc	abc	abc	1	2	3	Landline	Landline	Mobile				3
3	abc	abc	abc	abc	abc	4	5	6	Mobile	Mobile			4	5	6
4	abc	abc	abc	abc	abc	7	8	9	Mobile	Mobile	Landline		7	8
5	abc	abc	abc	abc	abc	10	11	12	Landline	Landline	Landline
6	abc	abc	abc	abc	abc	13	14	15	Landline	Landline	Landline
7	abc	abc	abc	abc	abc	16	17	18	Mobile	Landline	Mobile		16		18
8	abc	abc	abc	abc	abc	19	20	21	Mobile	Landline	Mobile		19		21
9	abc	abc	abc	abc	abc	22	23	24	Landline	Landline	Landline
10	abc	abc	abc	abc	abc	25	26	27	Mobile	Mobile	Mobile		25	26	27
Sheet2

Cell Formulas
Range	Formula
M2:O10	M2	=IF(I2="Landline","",F2)

 

[realdallas1]

That worked. Thank you very much time and consideration.

 

[Kerryx]

to acount for blanks like in K3 you could tweak to account for blanks

=IF(OR(I2="Landline",I2=""),"",F2)

 

[myall_blues]

That worked. Thank you very much time and consideration.

You’re welcome. Thanks for replying.