AnsweredAssumed Answered

Getting an Acronym right

Question asked by JohhnyHilly on Nov 5, 2013
Latest reply on Nov 5, 2013 by ninja

Title

Getting an Acronym right

Post

     I am trying to get an acronym calculation right for a company name but can't quite get there. This is what I have at the moment:

     Case (
     WordCount ( Company ) > 2 ; ( Left ( Acronym ( Company ) ; 3 ) ) ;
     WordCount ( Company ) = 2 ; ( Left ( Acronym ( Company ) ; 1 ) &""& Upper ( Left ( MiddleWords (Company;2;1) ; 2 ) ) ) ;
     WordCount ( Company ) = 1 ; ( Upper ( Left ( Company ; 3 ) )
     ) )
      
     For a company names that is for example: Vehicle and Automotive Service, that would shorten to VaA, but I am wanting to exclude the "a" from the "and" and it includes the 4th word so it reads VAS. How am able to exclude a word like "and" or a word that has lowercase letters?
      
     Thanks!

Outcomes