I split data in a cell into 2 cells but the alignment of the data after the split is different from cells that don't need to be split. I looked a formatting but can't see a difference.

I do not get correct results using the formulas you posted except when there are two dates in column B of the same MM/DD/YY format with a single space but no "as of" separating them. Regardless, there are better functions to use. Hopefully this will work better for you:

=IFERROR(TEXTBEFORE(B2," "),B2)

=IFERROR(TEXTAFTER(B2," ",−1),"")

The -1 in the second formula indicates you want the text after the last space character.

If there are no space characters in the text, TEXTBEFORE and TEXTAFTER will be errors. IFERROR says what to do in that case.