Converting text to columns

I have a large data-set with fields that needs to be converted to columns; I have used Excel's "Text-to-Columns" feature using delimiters but there isn't any specific delimiter as mentioned in the op...