Excel 2010, data validation - strip - on peoples names obtained from sharepoint

[Sayth]

I am trying to validate user names against another report. In my current excel report I have names obtained from a sharepoint name select.

such as

MCCARTHY, Sam;#1100;#JOKIL, Ricke;#1346;#OMARA, Jill;#4111

these are all contained within one cell.

If I attempt to use Text to columns, it is easily thrown by usernames that have 3 names and some of the formatting # etc.

Is there an option to copy in place but strip all non text characters excluding ';' and ',', except where they resolve to ';;'?

So that the output format would be in one cell.

MCCARTHY, Sam;JOKIL, Ricke;OMARA, Jill;