Search on a part of the cell value
 

Help,

I got a cell containing data with a structure of X-00000.
The zero's in the code can vary from 0 to 9. So the code can be
X-10000 or it can be X-89010.
Is it possible to search the value of a cell by just using the first
character from a cell?????????????

Tnxs in advance


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