ExcelBanter - Extracting part of a cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Extracting part of a cell (https://www.excelbanter.com/excel-worksheet-functions/238937-extracting-part-cell.html)

Colin Hayes

Extracting part of a cell

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

Extracting part of a cell

Hi

Try this formula in V1:

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

Regards,
Per

On 5 Aug., 03:35, Colin Hayes wrote:
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

Colin Hayes

Extracting part of a cell

In article
, Per
Jessen writes
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

On 5 Aug., 03:35, Colin Hayes wrote:
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

All times are GMT +1. The time now is 10:13 PM.