Excel - Convert MAC address to computer name 1

[rmiley]

I have one column of data with MAC addresses XX:XX:XX:XX:XX:XX that I would like to convert to computer names in another column.

The computer name should be sXXXXXXXXXXXX.

How can I drop the ":" from each MAC address and add an "s" at the beginning of the MAC address in another column?

Is this possible?

 

[TonyJollans]

Hi rmiley,

If your MAC address is in A1, then use ="s"&SUBSTITUTE(A1,":","&quot in cell B1 (or wherever you want it)

Enjoy,
Tony

 

[rmiley]

Thank You so much. You just saved me about 3 hours!!!

Thanks again