You can use something like this to change the 1st/last name order:

=RIGHT(A1,LEN(A1)-FIND(" ",A1))&", "&LEFT(A1,FIND(" ",A1)-1)

Perhaps someone else can assist with the space issue.

Deb wrote:
I have a spreadsheet that has over 5,000 rows and somehow the sort
order was
removed I need it to sort by column f which is Month/Year and then by
column
A which is labeled Member Name. The member name column has first and
last
name and has always been sorted by last name, but for some reason now
is
sorted by month/year correctly, but by first name instead of last
name. How
can I make this change and also add the blank lines back between the
Month/years going down the spreadsheet. there were also always blank
lines
splitting up for instance May-03 from June-03 ect. and now all the
blanks are
gone and all run together. No idea what happened to this spreadsheet.
Any
help will be appreciated.