| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting part of data | Excel Discussion (Misc queries) | |||
| Extracting part of a cell | Excel Worksheet Functions | |||
| Extracting part of Text from one cell to another | Excel Worksheet Functions | |||
| Extracting Part of a Date | Excel Discussion (Misc queries) | |||
| extracting comments in a cell and making these part of the Chart . | Charts and Charting in Excel | |||
Hybrid Mode
