removing single character?
I am having trouble figuring how to eliminate one character from account codes. Some of the codes I receive from my clients include "-" character that I need to extract. an example I receive TRN-100-10-07 what I need to use for my reports is TRN1001007. How can I eliminate the"-"?? some codes include the "-" others may have a space such as TRN 100 10 07 the space i need to eliminate also.
Thank you for your help,