I like the second one Bob... but the ":" (colons) aren't showing up ...
Any ideas?

Thanks so much!

LavaDude

"Bob Phillips" <[email protected]> wrote in
news:[email protected]:

> Just a play
>
> =IF(D2="","","host
> "&L2&IF(C2="","",".")&IF(OR(B2="",B2>30,),"",B2&"-")&C2&" { hardware
> ethernet
> "&LEFT(D2,2)&":"&MID(D2,3,2)&":"&MID(D2,5,2)&":"&MID(D2,7,2)&":"&MID(D2
> ,9,2) &":"&RIGHT(D2,2)&"; fixed-address "&M2&";}")
>
> or maybe
>
> =IF(D2="","","host
> "&L2&IF(C2="","",".")&IF(OR(B2="",B2>30,),"",B2&"-")&C2&" { hardware
> ethernet "&TEXT(D2,"00\:00\:00\:00\:00\:00")&"; fixed-address
> "&M2&";}")
>