THank you Joe for your reply...........Ron's answer was so easy for me, it
worked right away. I do appreciate your reply very much.............Peter
wrote in message
oups.com...
PeterM wrote:
I noticed that the first cell contained the last name of the
customer, then it has a comma, and then it has the first name. How can I
change that to last name in one cell and first name in another.

If A1 contains the "last,first" text, then:

TRIM(LEFT(A1,FIND(",",A1) - 1))

yields the last name, and

TRIM(RIGHT(A1,LEN(A1) - FIND(",",A1)))

yields the first name.

The use of TRIM() is defensive in the first case.
It is probably needed in the second case, unless
you know there is no space after the comma.