bad at using functions ...
 

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!

bad at using functions ...
 

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!

bad at using functions ...
 

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!