Forum Discussion
Solved
WHOLE UC word split
Wondered if anyone might assist or point me in the right direction. I need to split text by (UPPERCASE WORDS & LOWERCASE WORDS not UC characters), for example: From “16-04 CRICKET World Cup”. Too “...
Sorry Detlef in my haste I did not read your second question. Using excel 2016. Pasted the above into cell B1 as data starts in cell A1. Same error message. After pasting do I need to change any referencing. Garry
So that eliminates TEXTJOIN(). You need at least Excel 2019.
What remains are solutions with helper columns (depending on the number of blanks in your text) or VBA.
What remains are solutions with helper columns (depending on the number of blanks in your text) or VBA.
- Thank you Riny. Had no idea of this function. I will have to visit the library and investigate further. Many thanks, Garry
- Thank you Detlef. I can see that you have put in a lot of effort. I am going with your response. Many thank's Garry
- I will give it a go with helper cells. Need to start somewhere. Thank's for all your efforts. Garry