3 columns:
A B C
042-0-0-01234 100.100.1.210 00-00-00-00-04-D2

I will have a list in column A, numerical...042-0-0-01234,042-0-0-01235, etc
Column C will have a MAC and the last 2 segments are based on the last 5 of
column A. e.g. 01234 = 04D2 (first 4 segments are fixed)
Column B is decimal of last segment of column C, e.g. D2 = 210

I would like to scroll down column A, and fill in column B anc C, which I am
doing manual right now.

Way beyond me.....Any ideas?

Thanks,
Ron