Text to columns with carage return as deliminator

I have a single column in a sheet wth 4000 rows. The cell contains an address
with the lines seperated by the enter key (carage return) I need to split the
lines to indevidual columns.