Can you use a formula to split delimited data when number of characters in
each cell varies (rather than using Text to columns from Data menu).

For example:
Column A
1 Smith Sue
2 Wilson Jane
3 Vincent Michael

I want to split this data delimited by a space but can't use LEFT or RIGHT
functions as number of characters varies in each cell.

Please advise.

Thank you for your help!