search for multipl values - copy result

[Armitage2k]

Hello everyone.

I use this code to look for values like V1/V2/V3/V01 in my column. If the cell contains the value, nothing happens, if not, the whole row is deleted.

Please Login or Register  to view this content.

Now I would to find a way to copy the found value (which is either one of those) to column E in the same row.

A little note though, the values V1, etc. are part of a whole sentence (eg. "I thing a need a V1."), but I only need the V1 to be copied, not the whole cell content. I was looking around the net but could not find anything that be similar or of any help.

Thanks a lot,
A2k

[StephenR]

RegExp is a slightly tricky beast so there may be a shorter way, but I think this does what you want.

Please Login or Register  to view this content.

[Armitage2k]

works wonderfully. thanks a lot.