Need to Separate info from one cell into many cells

[bahstahd]

All this info is one cell.
How do I separate it into separate cells?


First Name: n

Last Name: k

Email: yk


Address: 81

City: memphis

State: Tennessee

Province:

Zip/Postal Code: 3812

County:

Country: United States

Phone no:773

Alternate no:773

Best Time to Call: Day

Desired business location:

Liquid Capital to invest: $30

Time Frame: 0 - 3 Months

 

[yee388]

Welcome to the board! To help, we'll need to know what your example data looks like: are there commas between items? spaces? It can be done, but we need to see what we're starting with.

 

[Oaktree]

Welcome to the board!

As a first pass, try Data --> text to columns.

 

[bahstahd]

Tried- There are little boxes after each break-
I cannot find a way of letting Excel know of these boxes nor can I copy and paste them into the find and replace screen and substitute them with another character to let Excel know that this is where the breaks are.