Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 09-16-2011, 01:39 PM
WLVanS WLVanS is offline Split Data from One Cell Into Two Windows 7 32bit Split Data from One Cell Into Two Office 2010 32bit
Novice
 
Join Date: Jan 2006
Location: Upstate NY
Posts: 13
WLVanS
Default

Steps to take.

1. Save your work sheet as a text file

2. Open up the text file in Excel as a .txt file. You should get the Text Import Wizard.

3. Click "Next" for step 2 of 3. In the area in the upper left hand corner of the dialog box, check on the box that says "Space". That should put a line between the numbers and letters.

4. Click "Next" to format the columns or "Finish" to complete the opening of the file. Your words should be separated by columns
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I fill the below emty cells with above cell data? Learner7 Excel 8 06-28-2011 12:10 PM
Move data from 1 cell to another cell Catalin.B Excel 1 06-25-2011 12:51 PM
Split Data from One Cell Into Two How to combine different cells data in one cell? Learner7 Excel 1 07-28-2010 12:07 PM
Displaying cell data in another spreadsheet Colonel Biggs Excel 0 07-01-2010 07:37 PM
Split Data from One Cell Into Two Copying data from one cell to another automatically mrphilk Excel 4 06-10-2010 11:52 PM

Other Forums: Access Forums

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


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