Thread: Is it possible
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Help on formula[_2_] Help on formula[_2_] is offline
external usenet poster
 
Posts: 10
Default Is it possible

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