Clear Text of specific character in a cell with VBA

Hi, I have the next table (I am attaching a spreadsheet, but I still describe the problem)

| header1 |
| --------------------------------------- |
| 000Model Test0Model Val00User0 |
| Perman000User0Model Name000000 |
| 000Perman00000000000000000000Name |

So I need to replace all Ceros with only one "," like this

| header1 |
| --------------------------- |
| ,Model Test,Model Val,User, |
| Perman,User,Model Name, |
| ,Perman,Name |


Is there a combination of formulas to do this? or with code in VBA?

Hi there,

Take a look at the attached version of your workbook and see if it does what you need. It uses the following code:

Please Login or Register  to view this content.

The highlighted value may be altered to suit your requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M