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
Bookmarks