ExcelBanter - Carriage return in cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Carriage return in cell (https://www.excelbanter.com/excel-programming/444116-carriage-return-cell.html)

gcotterl[_2_]

Carriage return in cell

How can I replace each comma followed by a space with a carriage-
return?

For example, a cell contains:

COL-ACTN-TYPE, COL-ACTN-NBR, ET-AL-IND

I want:

COL-ACTN-TYPE
COL-ACTN-NBR
ET-AL-IND

All times are GMT +1. The time now is 06:31 AM.