3 Fields

Name

Job code

Scan code

Name            John Brown

Job code        BRO1276/1/402

Scan code      John Brown BRO1276/1/402

Code is input.scan_code = name = job_code

All this is no problem apart from this

I want Scan code to read John Brown BRO1276-1-402

I want - instead of /

The reason I cant do this when entering the job code is that we cut and paste

Can anyone tell me how to change the / to a - in a formula

Thanks