I need to extract the first character after the second space in a string to create a reference number.
I seem to have partially figured it out but my formula picks the second space and the character I want to pick
AN EXAMPLE HERE
="ZMM/"&LEFT(F5,1)&MID(F5,FIND(" ",F5)+1,1)&MID(F5,FIND(" ",F5,FIND(" ",F5)+1),2)&"/"&MONTH(C5)&YEAR(C5)&"/01"
Thanks in advance