That worked well Jeffrey, but I omitted mentioning in the opening post that I wanted to add another cell at the same time. So, I inserted it into your code as follows:
Code:
=(SUM((TRIM(MID(SUBSTITUTE(B75,"+",REPT(" ",255)),1+(ROW(A1:A200)-1)*255,255)) & "0")/10)+SUM((TRIM(MID(SUBSTITUTE(B76,"+",REPT(" ",255)),1+(ROW(A1:A200)-1)*255,255)) & "0")/10))/29.5306
I suspect that my code is unnecessarily longwinded because there are two numbers in the first cell but the second cell only contains one figure. Can you condense it for me?
Incidentally, my project relates to a soli-lunar calendar.