I want to replace a given character (",") with a carriage return across a
large range of cells.

"Find What" = "," ; tab to the "Replace With" box, then type

0010

on the Number keypad while holding down ALT.

Click "Replace All".

Rgds,
Andy