Select word after **

  • Thread starter Thread starter et
  • Start date Start date
E

et

Hi all,

Anyone can help to tell me how to select words from a cell that located
after a **.

For example a have a setence in a cell that contains "I need help ** anyone
can do me a favor?", I want to draw the words "anyone can do me a favor?".

I know there must be a formula can do it, but I don't know how.

Thankyou
ET
 
Hi

if these are all in a column and you don't have any other * in this column
then the way i would approach it is ...
insert about 5 blank columns to the right of your column with the **

copy this column to the first blank column you inserted and then choose the
column
choose
data / text to columns
delimited
untick tab, tick other and type a *
tick, treat consecutive delimiters as one
click FINISH
now you can delete the column(s) you don't need
 
ET

to build on a previous response, a slight variation:

=MID(A1,FIND("**",A1)+2,LEN(A1)-FIND("**",A1)+2)

It then doesn't matter how long the original field was.

Regards

Trevor
 
Back
Top