Hi All,

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

Regards

B

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

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/