how can I set up a custom filter to ignore the last few digits
 

trying to screen out the last 4 digits of a telephone number

how can I set up a custom filter to ignore the last few digits
 

"VzBjim" wrote in message
...
trying to screen out the last 4 digits of a telephone number

=LEFT(A1,LEN(A1)-4)
--
David Biddulph

how can I set up a custom filter to ignore the last few digits
 

Hi,

try to use an auxiliar column excluding the last for digits, and fitler.

if you have 8 digits on the phone number use =right(a2,8)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"VzBjim" escreveu:

trying to screen out the last 4 digits of a telephone number