Extracting part of a cell

[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 Jessen]

Hi

Try this formula in V1:

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

Regards,
Per

 

[Colin Hayes]

Hi

Try this formula in V1:

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

Regards,
Per

Hi Per

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

I think the first A1 is W1.


Best Wishes


Colin