View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PeteD[_2_] PeteD[_2_] is offline
external usenet poster
 
Posts: 1
Default Search a 3 digit number and its variants

I am trying to search a 3 digit number and its variations in a file. If my
file starts with example 763 I want to go thru the rest of the file to see if
there is 367, 673, 736, 376, and 637. Then goes to the next number in the
file to search this 3 digit number and find its variations. And so until end
of file. I would like to put the number(s) found and it variants in another
column. I am a nubiw and no nothing about excel programming but do not know
where to look. Thanks