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
I can get it to work, but if the name changes, I have to amend my formula
Your assistance is most appreciated
Book1 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | |||
1 | Enterprise name: Barnaby | Barnaby | |||||||||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
L1 | =RIGHT(A1,SEARCH(":",A1)-8) |