Splitting Excel cell into multiple

[ruben23]

Hi, how do i split a single cell, who have name, address, phone number thats are separated by enter, is it possible if i can split this single cell into multiple cells-column & rows, so i would have different values per cell.


any suggestion..?

[zyzzyva57]

I think you want to do "Text to Column"

If so, this is how

If so, practice with the examples shown