Excel

I have an export of quickbooks to excel. I am trying to get all the customers info.

SO i exported it, only to find that it put the company name, address, state, zip all in one column. Is there a way to spilt this up?

I tried the data menu, text to columns tool. But I cant do it because it splits it up too far. Any other suggestions?