PL/SQL remove space from Location name

Hello expert,

Have added a couple of hundred Locations with name like
Sams Club # 1234
Now accounting tells us that the space between the hash tag and the number string
keeps them from lining the Location up with their billing system and
the Location name should be like
Sams Club #1234
That is, the fields in the table CCM_Location that are presently
 
should be
 
The Location_IDs are unique if that might help in identifying the Location_Name.

Thanks.

Allen in Dallas