Pulling sections of a string

Hello,

I have a column of strings that have the format XX.XXX.XXX.XXXXX.XXXX Really each section varies in length, but there are 5 sections, each separated by a period. And some sections will contain no information: XX...XXXXXXX.XX I would like to be able to separate this data into 5 columns. I know it'll probably consist of Mid() and Len(), but I don't know how to tell it to pull everything between the 3rd and 4th period for example.

Thank you