I fully understand how to use concatenate. However I am needing to find out the opposite of it. I have a sheet where column A is the full name of a customer. I want the name broken down into seperate cells for first and last names.

What I have:
A1 = John Smith

What I want
B1 = John
C1 = Smith

Thanks for all your help.