You need to copy and paste as VALUES the cells containing the concatenated string before deleting the source cells. It can't be done with a formula - is VBA a possibility?