Split Name into Columns

I have content in cell

“52 Allen Analyst”

i want to seprate the whole text in columns. i want 52 in one column and allen in second and analyst in third one. Please provide formula for this.

By: Kamaljeet

One thought on “Split Name into Columns

Leave a Reply

Your email address will not be published. Required fields are marked *