Quote:
Originally Posted by Claus Busch
Hi,
Am Thu, 22 Sep 2016 04:41:04 +0100 schrieb Smurfy:
Ok last one i swear ...
2016 0116 1821 - R.jpg
I need to pull the time out of that string, in this particular case
1821.
try:
=MID(A1,FIND("#",SUBSTITUTE(A1," ","#",2))+1,4)
If there are always 10 digits in front you can also try:
=MID(A1,11,4)
Regards
Claus B.
--
Windows10
Office 2016
|
I end up with 1821 not 18:21