First step is to separate the names from the addresses/phone numbers. Assuming your text is in column A , the first formula gives you the name in one column by itself, and the second gives you the address and phone number together.

=LEFT(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")))

=RIGHT(A1,LEN(A1)-MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789"))+1)

Separating out the pieces of the second formula will depend on how it's set up. You might be able to use text to columns there (like if the phone numbers start with a parenthesis).