VBA versus Worksheet function

P

Prashant

Friends,
I am trying to manipulate string in a column. The input
column is represented by the following values:
I_need_This_aaa
I_need_This_bbb I_dont_need_this_nnn
I_dont_need_this_xxx "I_need_this_ccc" not_this_yyy

the resultant column i am needing should look something
like this:
I_need_This_aaa
I_need_This_bbb
I_need_this_ccc

As my example represents, the initial few characters of
the required string are always common. And i have 1000s
of rows in this column.

So, can you help me out device a method to extract the
string either using a worksheet function or a VBA script.

Appreciate your help.

Prashant
 
P

Prashant

Nigel,

Thanks a lot. The method works. But is there something
that I can use the way we use the built in functions?
(without having to go to the VBA script each time for
running). Something that gets updated every time the
input cell changes.

Appreciate your help.

Prashant
 
Top