Add a comma after name

[shadyshawn]

Hi I just joined MREXCEL club after I found most of my excel answers from here when googling, and found folks here are really helpful.

As my first thread and question, I would like to learn how to add a comma after the first name in the cell. I have a list of names in one column as LASTNAME FIRSTNAME. I want to add a comma after the last name, without doing it in a new column. I'm assuming this has to be done thru VB? but I dont know anything about the codes yet. If anyone could help me out I would truly appreciate it!! Also, I want to add a comma after the last name only; so if I have a name that has three parts (e.g Jane Doe Jr.), only one comma is added after "Jane".

Thanks in advance for any help!

 

[Cindy Ellis]

HotPepper was responding to my observation that not all first or last names have only one part.
The OP has code that does what was originally requested. We're providing options for variations that he might not have thought of.

 

[motmit]

oh ok

OP -- origional poster?

 

[Scott Huish]

Yes, OP is original poster.

I have a list of names in one column as LASTNAME FIRSTNAME

Also, I want to add a comma after the last name only; so if I have a name that has three parts (e.g Jane Doe Jr.), only one comma is added after "Jane".

In the second example, although this is not how that generic name is typically used, the op said that Jane was the last name, although my formula does not take name suffixes into account.

 

[shadyshawn]

Cindy-- actually the code you provided betorX'mas worked great on my report, so thanks a lot!