Hi
you may use
InStr
for this in your comparison

--
Regards
Frank Kabel
Frankfurt, Germany


Hi All,

I am writing a macro that searches for a variable seven digit number
sequence. The number sequence is in a text field and is not in a
standard position (ie: in record one it is at position 20, record 2 -
position 9, record 3 - no entry, record 4 - position 12 and position
123, etc). The field contains other text and numbers that are not
required and may contain more than one valid number sequence. Does
anyone have an algorithm that could help me with this process.

Regards

BC


---
Message posted from http://www.ExcelForum.com/