excel query

[Nathan]

Hi
I am not very experienced in excel and would like to know if it is possible
to do the following:

I have 2 columns of data Old Tag and New Tag containing computer tags in the
following format - 3NT6W3J.

I need to to a search on each individual entry under 'Old Tag' to see if it
appears anywhere in the column 'New Tag' and then output the result in
another column as to whether it is there or not.

Can this be done or do I need to individually use the find command on each
tag.

Thanks for your time.

 

[Don Guillett]

look in the vba help index for FINDNEXT