Replace returned a series of numbers in the same cell. Sum? Total?

[tmccasland]

Hello, I seem to have lost my prior thread, but can pick up here: Now I have changed my codes to a number but need to create a score, so I need one number. I am giving my students a W when they Win and changing it using replace to a score of 5. They can win several times, so multiple W W W returns 5 5 5 in the same cell. Can I put a calculation or something similar that will eval Game 1 and return a total for the numbers in that cell. Need 15 when there is three fives. I have 3 other letters that are codes but that is now working fine. R returns a 1 etc in Game 1 field. Now I just need it to return a total of the numbers and not 5 5 5 but 15 instead. thanks

Games	Game1	SumOfTotal
w	5
w w	5 5
ww	55
www	555

[June7]

You mean this thread: https://www.accessforums.net/showthread.php?t=73835

Should be able to find your threads with MyThreads on the Quick Links menu.