Split Data in a Cell

Have you ever made a list of names in a spreadsheet and put the first and last name in one cell? Later on, you decide you want the first and last names to be in separate cells. Here is a video I created and posted on You Tube. Hope you enjoy.



For information on:
LEFT()
RIGHT()
LEN()
FIND()

you can see examples and explanations on my blog. Just look on the right hand side for the category the functions are in. They are grouped like they are in Calc.