INDIRECT function - need help

Originally Posted by dansparts

Neither of those formulas seems to work correctly.
The 2nd one got rid of the leading zero in sub-string #2, but re-attached sub-string #3.

Have you tried to add zero to that MID formula?

=TRIM(MID(SUBSTITUTE($A1," ",REPT(" ",100)),100,100))+0