Hi there,

I have a column with numbers such as
100/16-14-059-08W6/3
100/02-16-059-08W6/3
100/15-17-059-08W6/0
100/02-18-059-08W6/2

I need these to be rewritten in a column in the following format
100161405908W6003
100021605908W6003
100151705908W6000
100021805908W6002

So basically all dashes and slashes are removed, and there is a 00 added
infront of the last number.

I don't want to type it in since I have a lot of numbers, how can I do this
in excel?