# Need some Excel help

**URL:** <https://forums.speedlife.net/t/need-some-excel-help/205390>\
**Category:** NYSpeed Off Topic\
**Created:** [November 1, 2010, 10:27am UTC](https://forums.speedlife.net/t/need-some-excel-help/205390 "2010-11-01T10:27:48Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![ProgRocker](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/progrocker/32/5434_2.png) [@ProgRocker](https://forums.speedlife.net/u/ProgRocker)\
**Post date:** [November 1, 2010, 10:27am UTC](https://forums.speedlife.net/t/need-some-excel-help/205390/1 "2010-11-01T10:27:48Z")

</div>

Basically all I want to do is have the cells in a certain column auto-format to a Mac Address format. So if I enter 11AABB22FF00 it automatically changes to 11:AA:BB:22:FF:00. Anyone know how to do this? I’m an excel n00b.

---

<div class="post-metadata">

**Author:** ![Joe](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/joe/32/7219_2.png) [@Joe](https://forums.speedlife.net/u/Joe)\
**Post date:** [November 1, 2010, 10:31am UTC](https://forums.speedlife.net/t/need-some-excel-help/205390/2 "2010-11-01T10:31:25Z")

</div>

Probably the best bet would be format - cells - custom and enter your own format that way  
EDIT: Forgot these have letters, that won’t work. All the ways I’m thinking of involve 6 2-digit columns which is a PITA

---

<div class="post-metadata">

**Author:** ![ProgRocker](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/progrocker/32/5434_2.png) [@ProgRocker](https://forums.speedlife.net/u/ProgRocker)\
**Post date:** [November 1, 2010, 10:38am UTC](https://forums.speedlife.net/t/need-some-excel-help/205390/3 "2010-11-01T10:38:06Z")

</div>

> [@Joe](#):
>
> Probably the best bet would be format - cells - custom and enter your own format that way  
> EDIT: Forgot these have letters, that won’t work. All the ways I’m thinking of involve 6 2-digit columns which is a PITA

Yep tried the custom formatting…couldn’t get that to work…Also tried a formula in a helper cell? That also didnt work.

---

<div class="post-metadata">

**Author:** ![Joe](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/joe/32/7219_2.png) [@Joe](https://forums.speedlife.net/u/Joe)\
**Post date:** [November 1, 2010, 10:51am UTC](https://forums.speedlife.net/t/need-some-excel-help/205390/4 "2010-11-01T10:51:34Z")

</div>

I got it to work with 6 helper columns.  
You can hide them once you’re formatted up.  
A B C D E F G H  
0011A158CB10 00 11 A1 58 CB 10 00:11:A1:58:CB:10  
You would put the MAC into A, then B =LEFT(A,2) then C = MID(A,3,2) , D = MID (A,5,2) etc. then H would =CONCATENATE($A1,":","$B1,":" etc.)

---

<div class="post-metadata">

**Author:** ![ProgRocker](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/progrocker/32/5434_2.png) [@ProgRocker](https://forums.speedlife.net/u/ProgRocker)\
**Post date:** [November 1, 2010, 11:25am UTC](https://forums.speedlife.net/t/need-some-excel-help/205390/5 "2010-11-01T11:25:24Z")

</div>

Sorry to be an asshole but how do I go about putting everything in? Right now my D column is the host to the MAC addresses. Will this auto format them?

---

<div class="post-metadata">

**Author:** ![Joe](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/joe/32/7219_2.png) [@Joe](https://forums.speedlife.net/u/Joe)\
**Post date:** [November 1, 2010, 11:36am UTC](https://forums.speedlife.net/t/need-some-excel-help/205390/6 "2010-11-01T11:36:49Z")

</div>

PM me ur email, I’ll send you the worksheet I had it in and you can just copy/paste/update yours