I am extracting data from sharepoint and need a formula to change this string:
Text string;#40;#Some more text;#284;#and some more;#1003;#and some more again;#410
to this sting
Text string
Some more text
and some more
and some more again
the numbers between ;# can vary from 1 digit to...