Challenge #128: Settle the Score

[rslopez2]

Took a slightly different approach and created a lookup table with Delimiter & Score Values

-Find and Replace score values to get delimiter inserted between scores

-Text to colums to split scores to rows by round

-Find and replace Score with actual value

-Modified case once score was brought in to sum total score per player per round

Spoiler

[wwatson]

It took me a while to figure out how the scoring worked, once I figured that out I was able to work the enclosed solution.

[SophiaF]

Regex!

Spoiler

[garthn555]

Spoiler

[AlexSa]

thanks, please advise with any tips 

[mcultrera]

My solution. I presume there was a better way using Reg Ex, but I got it to work using Join with a static list for identifying which were uppercase/lowercase.

[Deevi]

I found this challenge a little difficult.. and I also end up using two tools that I rarely use - RegEx and Multi-Field Formula... anyway got to the answer finally!

Spoiler

[fmeo]

Spoiler