![]() Press the Alt F11 keys simultaneously to open the Microsoft Visual Basic for Applications window. ![]() See screenshot: Download and try it now ( 30-day free trail) Format mac addresses in cells by adding colon with VBA With below VBA code, you can format a range of numbers as mac addresses at once in Excel. Excel Formula To Place A Colon Address Download And Try See screenshot: Easily format mac address in cells by adding colons: The Add Text utility of Kutools for Excel can help you easily add colons to specified positions of a selected cell to format the number as mac address format. Select a blank cell, enter formula into the Formula Bar, and then press the Enter key. Excel Formula To Place A Colon Address Download And Try.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |