Data menu and how it works
 

I'm trying to change a list of addresses with company name, address etc. into
its own columns serately. All of the inforamtion is stacked in column A now.
I've tried text to columns but it won't let me because of the multiple forms
of data in the information.