Forum Discussion
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 is pasted into a "MASTER FORM" where the header stays the same, every day. But I spend time, shortening company names to around 4-6 letters (around 200 jobs).
| 12345 | PURPLE MACHINING |
| 12346 | AVERY REMOVEABLE |
| 12347 | HABIT GRILL |
| 12348 | GOVERNMENT |
| 12349 | BOEING |
| 12350 | NICK ENGINEERING |
| 12351 | ROMER |
| 12359 | TESSA LITE |
1 Reply
- 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)
