Share via

Changing a number format

Anonymous
2014-09-24T08:28:03+00:00

Hi

I work with an ISP and was handed this task to check a bunch of MAC addresses. the list given to me are from the termination system and is in the format xxxx:xxxx:xxxx , the format i need is xx:xx:xx:xx:xx:xx wich is required to locate account on radius manager. generally i would do this manually, but the amount of data i have is really bulky. i need help to fast track this.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2014-09-24T09:13:26+00:00

Simple Mid formula will do it for you:

Copy paste the below formula in the column next to xxxx:xxxx:xxxx. You might need to replace A1 with the right cell reference in your worksheet.

=MID(A1,1,2)&":"&MID(A1,3,2)&":"&MID(A1,6,2)&":"&MID(A1,8,2)&":"&MID(A1,11,2)&":"&MID(A1,13,2)

Was this answer helpful?

1 person found this answer helpful.
0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2014-09-24T11:15:10+00:00

    I am glad it worked. Kindly mark my response as an Answer.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2014-09-24T11:08:04+00:00

    oh hey, that works

    thanx

    Was this answer helpful?

    0 comments