Remove repeating characters (like dashes in a MAC address value)

Is there a quick/easy formula that could replace every instance of a specific character with another value, reguardless of the number of times it appears in a cell?

Example I want to turn the following computer MAC address: "78-45-D1-D3-BB-00" into "7845D1D3BB00" so I can compare it to values from another datasource.

I started to write the following formula and got a headache... =LEFT(A2,FIND("-",A2)-1)&MID(A2,FIND("-",A2,2)+1,2)........

NOTE: I am trying to do this without using the Excel FIND & REPLACE (<CTRL> + H)

Thanks! Tony

Use SUBSTITUTE,

=SUBSTITUTE(A1,"-","")

Where A1 contains your text

Originally Posted by Only4Excel

Use SUBSTITUTE,

=SUBSTITUTE(A1,"-","")

Where A1 contains your text

There it is! I totally forgot, couldn't remember and find! Thanks Only!