I have a data base of 8000 names in Excel that are listed in one field as SMITH, JOE. I need to reverse the names and possibly seperate them into two fields. They also need to appear in proper case. (Joe Smith) Any ideas?

Perhaps the easiest way is to use Data > Text to Columns

If that doesn't work, there are some formulas that can help.

Text to columns to split on a delimeter such as your Comma,

Or a couple of formulas to do this in one
to get First Name
=PROPER(TRIM(RIGHT(A1,LEN(A1)-FIND(",",A1))))
to get last name
=PROPER(TRIM(LEFT(A1,FIND(",",A1)-1)))

but this will only work for the data in the above format and without any errors
post back if you have any more questions