How do I search for a ‘, ‘ and replace with ‘, ‘ in SQL Server Management Studio’s editor

CTRL+H

Find what: ', ' (No Quotes)
Replace With: ', \n' (No Quotes)

Expand the Find options and tick the Use Regular Expressions checkbox.