Re: Selecting a particular column

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

On May 12, 4:47 am, "Doug Robbins - Word MVP"
<d...@xxxxxxxxxxxxxxxxxx> wrote:
Use Ctrl+A then Ctrl+C, then go to Excel and with a single cell selected use
Ctrl+V.  You will then have the numbers in two columns in Excel and you can
then just delete the second column.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Vishwas Upadhyaya" <vishwas...@xxxxxxxxx> wrote in message

news:298360d8-2522-4c68-864a-18c2a7acfb0a@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx



Hi all,

I have a word file in which the data have been entered in two columns
without the table being created.  A tab seperates the two columns in
every line of the data as shown below:

4.223391 244.140625
4.149764 488.281250
4.204984 488.281250
4.315426 244.140625
4.333833 244.140625

This data table actually has more than few thousands of lines.  I need
to select only the first column and copy it to another notepad file or
excel or another word file. Can anybody help me doing this? I dont
care if the second column gets deleted completly.

Regards,
Vishwas- Hide quoted text -

- Show quoted text -

Using Ctrl+A then Ctrl+C, then go to Excel and with a single cell
selected use
Ctrl+V. doesnt help at all. I bet you didnt try this procedure with
the sample data I have produced here. If you copy paste the data into
the excel cell, all the data gets copied into the single cell that you
have chosen; although it appears as if its split.

regards,
Vishwas
.

Relevant Pages

  • Re: Selecting a particular column
    ... he does specify a tab. ... to Excel I actually got the required result by using Paste Special - Text. ... then go to Excel and with a single cell ... doesnt help at all. ...
    (microsoft.public.word.formatting.longdocs)
  • Re: random vs "real world" actual numbers
    ...  The first column are random numbers and the second column are ...  I apply the following Excel equations to the random ... number of standard deviations in Chebyshev's theorem. ... the 48.94'th percentile instead of the 50'th percentile? ...
    (sci.math)
  • Re: An easier formula please......
    ... number and "$A3" is the post type: ... At this point you could gain even greater efficiency by using indexing to ... and a MATCH formula in its second column. ... Even though Chancery!$B$8:$B$9997 would be sorted, Excel could ...
    (microsoft.public.excel.worksheet.functions)
  • Re: how do i count unique items in word table?
    ... second column of the first table in the document, ... Dim arange As Range ... I suggest you replace the table by an Excel ...
    (microsoft.public.word.tables)
  • Re: An easier formula please......
    ... detailing how many entries of type 'A', 'B', 'C' and so on were input for ... At this point you could gain even greater efficiency by using indexing to ... and a MATCH formula in its second column. ... Even though Chancery!$B$8:$B$9997 would be sorted, Excel could ...
    (microsoft.public.excel.worksheet.functions)