Hi,
I have two columns of names A and B (A=First name B=Last name). My question
is, without changing the column A and B, how could be the Macro defined so
that column As or Bs characters are if less than four, the comas (,)
inserts into to make it four i.e. €œLeo=LEO,€� €œA=A,,,€�. Blank fields should
stay blank and if its possible if the small letters of name in column A or B
can also be capitalized in the same Macro. To explore the possibilities I
thanks in advance€¦

Sincerely Shan