Forum Discussion

Copper Contributor

Aug 25, 2017

Formatting Rule or Conditional formatting?

Good Morning! I was trying to see if there was a Formatting Rule or a Conditional Formatting function that I could use, to shorten company names, to 4 letters, automatically. All of the information...

excel

Formulas and Functions

JKPieterse

Silver Contributor

Aug 25, 2017

You could remove all vowels and spaces and then take the first 6 characters:
=LEFT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"A",""),"E",""),"O",""),"I",""),"U","")," ",""),6)