How to Replace Nos {1,2,3,4,5,6,7,8,9} with some text appended to the number and a comma?

How to Replace Nos {1,2,3,4,5,6,7,8,9} with some text appended to the number and a comma?

Dear Forum,

If I have a value in a cell such as 12345 then I need that to be shown as below:

Sheet1,Sheet2,Sheet3,Sheet4,Sheet5

If the value is 12040 then I need to just show:

Sheet1,Sheet2,Sheet4

I dont how to use the Replace, Substitute Function for a single character?

Warm Regards
e4excel