I have an excel spread-sheet with following data. I need help in reducing the ";" down to 1. if there is only 1 semi colon then leave it as is.
It appears simple but i am just not able to solve it.
Any help will be greatly appreciated.

2120;;;;;;;;;;;;
;;;;idea;22045;;;;;;;
;;;;xxxxx;00000;;;;;;;detail


Thanks in advance.