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

Something like this should do...
=IF(LEN(A1) = 0, "", IF(LEN(A1)= 4, UPPER(A1), UPPER(A1) & REPT(",",
4-LEN(A1))))
--
HTH...

Jim Thomlinson


"Help on formula" wrote:

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