I have two worksheets of data from automobile license plates. The data
is a string - 7 characters. I have to compare the license plate data
from each worksheet, find the matches and output the ones that match in
a third sheet. I would use an IF statement since that'd be pretty easy,
but my program not only has to find the absolute matches, but also match
ones that match 6 of the characters, 5 of the characters, 4 of the
characters and so on.

I've already set up my ranges from the three sheets. I think the best
way to be able to do this would be using mid$, but it really confuses
me, and I'm having the hardest time finding a website that talks about
how to use it.

If anyone could explain to me mid$ or point me to some useful sites,
I'd be eternally grateful.

Thanks,
Cami


--
cliodne
------------------------------------------------------------------------
cliodne's Profile: http://www.excelforum.com/member.php...o&userid=28774
View this thread: http://www.excelforum.com/showthread...hreadid=485763