Text To column wont work because I have name and address info in a single
cell in this format. Each cell has different data representing different
addresses.

Name
St # St Name
Phone Number
City, State zip

I want a formula or something to take first line and put in one column, the
2nd line in another column and the 3rd line spread across 3 columns. Although
if you could just find a way to split each line into a column, that would
work.

Once again, Text to colun won't work, I have multiple cells with diffeent
addresses, they are not all the same and there are no delimiters.