Forum Discussion
Jamie Batie
Aug 25, 2017Copper Contributor
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...
JKPieterse
Aug 25, 2017Silver Contributor
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)
=LEFT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"A",""),"E",""),"O",""),"I",""),"U","")," ",""),6)