I have a time consuming task of adding the MAC separator periods into a scanned list of MAC addresses. It is a requirement that I add the periods and am currently doing it manually. I know there are macros to automate things and I've made some using the record feature but I don't think that's going to cut it for this task. I'm thinking this is going to require VBA and I have pretty much no knowledge of VBA, the closest would be old school BASIC.



If there's a better way to do this task than manually I'd love some pointers and help. Thanks in advance!


EDIT:
The format of the document, depending on how many addresses I'm scanning in, is generally in three or four columns using the table function, so it looks like this:

0090c2e4e993 0090c2e8844f 0090c2e77aa9 0090c2f43de4
0090c2e66790 0090c2e03e4e 0090c2d45fe3 0090c2edd334


These need the periods inserted. The forum removes the spacing between columns so imagine a bit more spacing between them.