Is it possible
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
|