Challenge #356: Spelling Bee

[MajorData]

スポイラ

Nice one! I went through 3 different approaches to the RegEx. Did not attempt a macro, but I will check out some other answers. 

[rmassambane]

356

[patrick_digan]

Dynamic without any regex or macros

スポイラ

I used the Dynamic Replace and the replacechar function

[TonyAndriani]

This one was fun.

スポイラ

[binu_acs]

スポイラ

[Georgia251]

Not the most elegant of solutions but it got me the result I needed

[cameronfraser]

Good practice for the append tool and formulas.

スポイラ

[Kenda]

スポイラ

[logdog0411]

スポイラ

Great challenge! Took me a few attempts to figure out the RegEx elements. 

See you next week!

[AkimasaKajitani]

My solution.

スポイラ