Does anyone have any experience of using formulas to split a single string into multiple strings please?
I'd like to take strings like this:
Joe Bloggs*Residents Services*Finance*Central Services
and put everything between the second to last asterix and the last asterix, into one string
and put everything after the last asterix into another string
so I'd ultimately end up with:
string 1 = 'Finance'
string 2 = 'Central Services'
The number of asterixes in a sentence will vary so I can't do this from the left hand side of the string, only the right hand side...is this even possible?
Any advice would be really appreciated Thanks!!!