I have successfully cleaned my data up to the point
where ";" is are now at the beginning and end of the
field. Please I need a macros (Office XP)to clean up this
huge database.

For example:

;PM;LE; to become PM;LE

;QM to become QM

LE;QM; to become LE;QM