Hello experts and gurus,
I hope everyone is having a great start to the year.
Can you please advise how i can extract the Name of the company given that sometimes the cell includes the company name as is, other times the name is preceded by a 3 letter space minus space (eg. "AUS - "). The three letter prefix changes however the format is always the same
ROM - Leadership SRL should be > Leadership SRL
TTI Success Insights should be > TTI Success Insights
AUS - Vernar Consulting should be > Vernar Consulting
Target Training should be > Target Training
Thank you!
Bookmarks