View Single Post
  #10   Report Post  
Smurfy Smurfy is offline
Junior Member
 
Posts: 10
Default

Quote:
Originally Posted by Claus Busch View Post
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