I'm sure this will come as a really simple question to the rest of you, but I
have a column with names in it; I want to divide them into first and last
names. How can I do this?

I started with finding the space in between the first and last names, like
this:

SEARCH(" ",A2)

Then when I got the number of the space, I started a conditional statement:

IF(SEARCH(" ",A2)0, . . . .)

But that's where I lose my line of thinking.So I'm telling it that if it
finds a space, then I want it to return everything BEFORE the space to one
column and then I need another function to return everything AFTER the space
in another column.

TIA for your help!