Split Text in Cell

J

Jen

I have a cell that contains first and last name by space. I need to create
two cells. First and Last

How can I do this.

Thanks like always Jen
 
K

KARL DEWEY

You are using the term 'cell' which is an element in Excel. This group is for
Access. Which are you working in?
 
Top