Splitting Excel cell into multiple

ruben23 · #1 07-21-2009, 12:24 PM

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 · #2 07-23-2009, 03:49 AM

I think you want to do "Text to Column"

If so, this is how

If so, practice with the examples shown

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Opening multiple Excel files within the same Excel window.	lost9471	Excel	2	05-01-2010 01:57 PM
How to transfer multiple cells from excel to word by formulas	justziggy	Word	5	05-23-2009 02:33 AM
WORD 2003 Need help splitting a HUGE Document	dlawson	Word	4	04-14-2009 12:22 PM
Auto-populate an MS Word table cell with text from a diff cell?	dreamrthts	Word Tables	0	03-20-2009 01:49 PM
paste formated text from Word to only one Excel cell	heron	Word	1	12-06-2005 02:37 AM