Thread: how can I set up a custom filter to ignore the last few digits
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Marcelo Marcelo is offline
external usenet poster
  
Posts: 1,047
Default 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
Reply With QuoteReply With Quote