View Single Post
  #8   Report Post  
Posted to microsoft.public.word.formatting.longdocs
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default Selecting a particular column

Indeed, he does specify a tab. I missed that. But from the fact that he used
Table | Convert | Text to Table separating at spaces, it would appear that
the intervening character is actually a space (as it appears to be).

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"DeanH" wrote in message
...
From your inital description you did say that there is a tab between the
columns.
I copied your text and inserted the required Tab between the columns, went
to Excel I actually got the required result by using Paste Special - Text.
Hope this helps
DeanH

"Vishwas Upadhyaya" wrote:

On May 12, 4:47 am, "Doug Robbins - Word MVP"
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" wrote in message

...



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