I have a colum of data with names both first name and last. is there a
formula to pull out the first name and one to pull out the last name? a cell
might current read "John Smith" i want to separate the name so i have one
field reading "John" and the next field reading "Smith". The names will vary
in character length so i cannot use a simple left() command.