Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-21-2009, 12:24 PM
ruben23 ruben23 is offline Splitting Excel cell into multiple Windows Vista Splitting Excel cell into multiple Office 2007
Novice
Splitting Excel cell into multiple
 
Join Date: Jul 2009
Posts: 1
ruben23 is on a distinguished road
Default Splitting Excel cell into multiple


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..?
Reply With Quote
  #2  
Old 07-23-2009, 03:49 AM
zyzzyva57 zyzzyva57 is offline Splitting Excel cell into multiple Windows 7 32bit Splitting Excel cell into multiple Office 2007
Expert
 
Join Date: Mar 2009
Location: Dawsonville, Ga (NE of Atl)
Posts: 355
zyzzyva57 is on a distinguished road
Default

I think you want to do "Text to Column"

If so, this is how


If so, practice with the examples shown
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Splitting Excel cell into multiple Opening multiple Excel files within the same Excel window. lost9471 Excel 2 05-01-2010 01:57 PM
Splitting Excel cell into multiple How to transfer multiple cells from excel to word by formulas justziggy Word 5 05-23-2009 02:33 AM
Splitting Excel cell into multiple 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
Splitting Excel cell into multiple paste formated text from Word to only one Excel cell heron Word 1 12-06-2005 02:37 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:32 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft