Bridget has attended:
Excel Intermediate course
Excel Advanced course
PowerPoint Intermediate Advanced course
Splitting a cell
How do you split a cell so that the first name goes to one cell and the last name goes in another cell.
RE: Splitting a cell
Comma Delimited Text
Highlight the range of cells where the first name and last name is, then select data > text to columns...
then when presented with the dialogue box, choose the top option, which says 'delimited', then click next.
After that, select the box that says 'spaces' and de-select any other boxes that may be ticked and then click next, then finish and voila!
There you have it...
Hope this helps
Paul