Need Excel Help (again)

Kevy Baby · 12-10-2007, 09:07 PM

I really tried to figure this one out, but just couldn't find the right solution. I am 98% certain that this is doable in Excel and I am fairly certain that the solution involves the "LEFT" "MID" and/or "RIGHT" functions, but I seem to be missing something.

Basically, I want to be able to take a cell containing a first and last name and split it into two different cells (FName and LName).

What am I missing?

12-10-2007, 09:07 PM	#1
Kevy Baby Chowder Head Join Date: Jan 2005 Location: Yes Posts: 18,500	Need Excel Help (again) I really tried to figure this one out, but just couldn't find the right solution. I am 98% certain that this is doable in Excel and I am fairly certain that the solution involves the "LEFT" "MID" and/or "RIGHT" functions, but I seem to be missing something. Basically, I want to be able to take a cell containing a first and last name and split it into two different cells (FName and LName). What am I missing? __________________ The thing about quotes on the internet is that you cannot verify their validity. - Abraham Lincoln
	Submit to Quotes

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode