LEN, MID

[Sefty]

Hello,

please help, how do you do it if you want to take a character into a number 2, 5 like in the result column?
I've tried using if, len, and mid but it doesn't work.
Thanks

=IF(LEN(A2)=7;MID(A2;3;1);ISBLANK(" "))

 

[Michael M]

Try

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,0,""),"[",""),"]","")

 

[Sefty]

WOW...
it worked, thanks a lot Master!!

 

[Michael M]

Glad to help...