I have tried to set up a formula to extract the name to the right of : . in this instance I want Barnaby extracted
I can get it to work, but if the name changes, I have to amend my formula
Your assistance is most appreciated
Book1ABCDEFGHIJKLM1Enterprise name: BarnabyBarnabySheet1Cell...