Extracting part of a cell

  • Thread starter Thread starter Colin Hayes
  • Start date Start date
C

Colin Hayes

Hi

In column V I need to place the text which appears after the text "Ref :
" in column W.

So , for example , if W contains

abcdef ghi jklm Ref : abc23456

V would become

abc23456

Can someone help with this?


Grateful for any assistance.


Best Wishes
 
Per said:
Hi

Try this formula in V1:

=MID(A1,(FIND("Ref",W1)+6),1000)

Regards,
Per
Click to expand...

Hi Per

OK - thanks for that. It solved my problem perfectly.

I think the first A1 is W1.


Best Wishes


Colin
 
Back
Top