Hi Joe,

I believe you are trying to convert the entire list in one go using the formula but you need to enter formula for each row. Just enter it in one cell i.e., cell c1 and drag it down.

Also have a look at the function Replace as well alongwith Substitute,

Post the sample file if you face any challenges. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>