Do a find and replace on the comma replacing with comma blank space... Record
it as a macro if you need...
--
HTH...

Jim Thomlinson


"mira" wrote:

Can someone help me figure this out?

HOW IT IS NOW: Doe,Jane
HOW I WANT IT TO BE: Doe, Jane

Basically, I want a space in between the comma and the first name.

Also, here is another one:

HOW IT IS NOW: Doe,Jane,Smith
HOW I WANT IT TO BE: Doe, Jane, Smith

THANK YOU!