Combine 2 functions into 1

[Charon_]

I tried to do a search for this but the search function was not working.

I have an excel sheet that I can scan Mac address into. The reason I created the sheet is because when I scan them in they are uppercase and do not have separators. I would like to combine 2 excel functions into 1

This one

=LOWER(C2)

and this one

=LEFT(E2,2)&":"&MID(E2,3,2)&":"&MID(E2,5,2)&":"&MID(E2,7,2)&":"&MID(E2,9,2)&":"&MID(E2,11,2)

[ConneXionLost]

Hi Charon_,

Does this work?:

Please Login or Register  to view this content.

Cheers,

[Charon_]

Thank you ConneXionLost