Splitting information from one cell into two cells

C

Craig

I have a multi page workbook. On Sheet 1 I have a cell
that contains a person's full name (first and last
name). I would like to automatically transfer the name
to other sheets in the workbook but I would like the
first and last names to be placed into separate cells in
Sheets 2, 3, 4, etc.

How do I do this?

Thanks!!
 
Top