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
|