View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Elkar
 
Posts: n/a
Default 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?