Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Selecting right part of text string
Hi
I have cells that are populated by a data dump from a work management system and the text will always appear in a preformatted manner eg: VODAFONE P3 INC526642 SITE: SOJ Shotover Jet HQ DUE 4/11/09 16:09 I want to select the date only from this string - which will always appear after the word DUE .. I have tried the formula below (from this forum) though am coming unstuck and it is not returning what I want. =RIGHT(R2,FIND("DUE ",R2&"DUE ")) The above formula gives me this result ... 26642 SITE: SOJ Shotover Jet HQ DUE 4/11/09 16:09 TIA ... -- Sue Compelling |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete part of a text string | Excel Worksheet Functions | |||
Extract part of a text string | Excel Worksheet Functions | |||
Omitting right part of text string | Excel Worksheet Functions | |||
How do I extract part of a text string | Excel Discussion (Misc queries) | |||
Use a formula to delete part of a text string? | Excel Worksheet Functions |