remove a dash from part numbers
You could use Find/Replace. Find - and leave the Replace With field blank.
Or, you could set up a formula in an adjacent column.
=SUBSTITUTE(A1,"-","")
HTH,
Elkar
"Mr Happy" wrote:
I have a database that have part number with dashes (ex. AX-2912) is there
a way to remove the dash?
|