Select a text in a range of cells

Hi all

Need your help, i have my head about to explode and dont have solve this yet :S. So any one can help??

Problem is:

Have a range, always not same, change everyday of size of rows

Exemple D2:G500 (tomorrow maybe G280)

In every row have text like this

Paulo Miguel : Setubal : Casa Campo : corridas v descanço
etc : etc : etc v etc

Point is i need in every row copy "etc v etc" to other colunm

CAn anyone help me whith promula or vba code for aply in a button (better to me) ??


Many thanks

pcal72,

Try this:

Please Login or Register  to view this content.

Hi thanks for help, will test it in a next hours.

NOTE: "etc v etc" is different for all rows all time only " v " will be always there

The structure is etc : etc : etc : etc v etc (all etc's will change allways)

thanks

pcal72

Originally Posted by Pulsus

pcal72,

Try this:

Please Login or Register  to view this content.

Thanks my friend for try to help

but it wont resul cause it devide all words in colluns

i need all text that ends "etc v etc" imediatly defore last ":"

thanks

pcal72

pcal72,

Try this out, I think now will work:

Please Login or Register  to view this content.