how do i remove hyphens from between numbers witout having to edit manually I
have a column of 3000 numbers similar to below.

0-7643-2200-1 becomes 764322001

0-7643-2299-X becomes 076432299X

if i format the column as text and then use the search and replace dialog
box Ctrl-H search for hyphen and replace with nothing it works on numbers
which end in a letter ie -X but will remove the 0 at the beginning of numbers
not ending in a letter ie -1 in my example

Can anybody help
Thanks Ian