Hi Karla,
You can select the column and do, Data, Text to columns and choose the
separator you have between both, maybe a "," or an space. it will do the trick

"Karla B" wrote:

I'm trying to split the first and last names in a cell and have it appear it
two seperate cells so I can create some labels.
I've used this function in Excel in the '03 version and I can't seem to find
this formula in the '07 Excel version.
Can someone please help me. I know it was a pretty easy formula.

Thanks,
Karla