i want to see if Length of cell is 6 then take the mid value from space 9 on cell f187 otherwise take the value from space 11
i am trying to use this formula but it is giving error, if someone help
=IF(LEN(+A187=6,MID(F187,9,35),LEN(f187,11,35))) assume A187 = 123456
Thanks for help
Bookmarks