Numbers chokes importing text file

My client sends me a text file of some financials. In Excel, I can import the file and get a dialogue that walks me through the process of parsing the file into columns. In Numbers, it will read the file and import the entire line into one cell. I can't figure out a way to parse the cell into columns. If you know a way to do this, please advise.