Dear Friends,
I need a formula that can produce the desired format of a large number of names that separate the initials appear at the end of the name by inserting a comma after the last names.
Please see the attached sample. Also, please note that many last names includes spaces and some of the last names consist of two words as well.
Basically, a formula that start on the right of the cell, find the first space and insert a comma just before the first space. I could not figure it out myself.
Many thanks in advance, Taisir
Bookmarks