Select the column or cells of data to change and do

Edit=Replace

What: ,
with: ,<space

use an actual space.

--
Regards,
Tom Ogilvy

"mira" wrote in message
...
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!