excel query
 

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.

excel query
 

look in the vba help index for FINDNEXT

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Nathan" wrote in message
...
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.