Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-30-2010, 04:05 PM
speedycorn1 speedycorn1 is offline Selecting specific text out of a series of columns Mac OS X Selecting specific text out of a series of columns Office 2007
Novice
Selecting specific text out of a series of columns
 
Join Date: Oct 2010
Posts: 3
speedycorn1 is on a distinguished road
Default Selecting specific text out of a series of columns

I have a set of data that looks something like this, but is much, much longer:
-0.799, -3.840e-7
-0.798, -3.793e-7
-0.797, -3.759e-7
-0.796, -3.723e-7
-0.795, -3.670e-7
-0.794, -3.655e-7
-0.793, -3.642e-7
-0.792, -3.616e-7


-0.791, -3.595e-7
-0.790, -3.578e-7
-0.789, -3.551e-7
-0.788, -3.535e-7
I need to select only the left column, but can't without also selecting the right column. I could go through the data and individually delete each entry in the right column until I was left with only the left column, but the columns go on for about 25 pages, so that would be very tedious. Is there anyway to only select only the left column? Can this be done in Excel?
Reply With Quote
  #2  
Old 10-30-2010, 04:18 PM
Kimberly Kimberly is offline Selecting specific text out of a series of columns Windows 7 Selecting specific text out of a series of columns Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

hold down an ALT key as you drag to select

Hope it works. It would help to know how the 2 cols came to be... table? Newspaper cols? tab characters?
Reply With Quote
  #3  
Old 10-30-2010, 04:27 PM
speedycorn1 speedycorn1 is offline Selecting specific text out of a series of columns Mac OS X Selecting specific text out of a series of columns Office 2007
Novice
Selecting specific text out of a series of columns
 
Join Date: Oct 2010
Posts: 3
speedycorn1 is on a distinguished road
Default

The data's from analytical chemistry software, but I think holding down the alt key let me select what I needed, so thanks!
Reply With Quote
  #4  
Old 11-01-2010, 02:58 PM
BrazzellMarketing BrazzellMarketing is offline Selecting specific text out of a series of columns Windows XP Selecting specific text out of a series of columns Office 2007
Competent Performer
 
Join Date: Apr 2010
Location: Galax, VA
Posts: 120
BrazzellMarketing is on a distinguished road
Default

That would work. Here's another option that may give you other manipulation options in the future, and may create less work for you.

Copy and past all the values into notepad. Save as a separate file with a .csv extension (not .txt). This tells the computer it's a comma separated values sheet. That's a simple form of spreadsheet. Open your CSV in Excel. In Excel, it will open your data in two columns, and the commas will have disappeared. Now you can delete an entire column in one stroke, sort by values, do operations, etc. When you save, save as file type CSV. You will then be able to copy the CSV text and paste it back into your word document.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I import text columns with specified spacing between words w/o losing format? Fucius Word 0 08-09-2010 06:23 PM
Selecting specific text out of a series of columns How to compare 2 columns with other two columns in EXECL 2007? Learner7 Excel 5 06-12-2010 09:54 AM
Selecting specific text out of a series of columns how to center text in multiple columns galiwock Excel 1 05-12-2010 09:02 AM
Selecting a Text Box gajesh Word 0 09-02-2009 11:45 PM
How do i get my text in columns straight and inline in word 2007? terrasaw Word 0 09-03-2008 06:00 AM


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


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