separate Name into two columns

[JohnSeito]

Hello all,

I am wondering if anyone know if there is a formula that can separate a name which sometimes have two words or one or two space. For example a formula that can separate a name by first space in one column and the second half in the second column.

example : David T Blain

name is in column A,

column B is David T
column C is Blain.

I don't think this is possible with a formula, but if you think it is let me know.

I think it would be more efficient to do this with a macro, could you please see if you could provide a macro that can do this.

Thanks