JohnyG
11-05-2008, 12:05 AM
I need to find codes like ?ach?, ?vim?, ?rck? etc in Reference column (Column B). If found any of the above codes then paste that code (vim or ach or rck) in next column(Column C).
For instance:
B2 contains ?07-08/1429/vim/rsh/sub? so vim needs to be pasted in C2. In case if none of the code found then in column C it will display ?Not found?.
Sample data and output is attached.
Regards,
Johny
For instance:
B2 contains ?07-08/1429/vim/rsh/sub? so vim needs to be pasted in C2. In case if none of the code found then in column C it will display ?Not found?.
Sample data and output is attached.
Regards,
Johny