Hello asuguy83,

Welcome to the Forum!

I don't see any values on "Sheet1" that are separated by ";#". Can you provide a sample of data that does? You can include in your reply. You don't need to post the workbook again.