When I parse text, Excel trims the result. Is there a way to avoid this?

For example, I have a cell with "Master " and I want to split it into
"Master " and " ". When I try, it returns "Master" and "".

Any suggestions?