Extract date / extract time / strip data
Hi,
Am Wed, 21 Sep 2016 12:37:17 +0100 schrieb Smurfy:
Ok the first two work but I guess I wasn't clear, I need to strip that
information out and leave the remaining. The formula you posted results
in removing the information I need.
try:
=MID(A1,FIND("#",SUBSTITUTE(A1," ","#",4))+1,99)
Regards
Claus B.
--
Windows10
Office 2016
|