Selecting right part of text string
Hi,
Looking at this again it seems you may want the time also so if that's the
case use this
=TRIM(MID(R2,SEARCH("due",R2)+3,256))
Mike
"Mike H" wrote:
Hi Sue,
try this
=TRIM(MID(R2,SEARCH("due",R2)+3,9))
Mike
"Sue Compelling" wrote:
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
|