I need a formula to seperate first and last names into different cells

Hello all,

I was given a database that has the person's first and last name in the same cell. However, I need to split them up into seperate cells. Is there a quick and easy way to do this? I would assume you use the LEFT function and and select the number of characters to the right of a space, but how do I get the formula to select these cells and seperate them?

UPDATE: SOLVED