Excel imports

I have a user that has data that when imported into Excel places all the information of one row in one row. He wants to break up the information into three columns per row. Attempting to import it as comma deliminated or another other format does not work. Is there a way to divide the information into columns once it is in Excel?