(Msg. 1) Posted: Sun May 11, 2008 9:39 pm
Post subject: Selecting a particular column Archived from groups: microsoft>public>word>formatting>longdocs (more info?)
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:
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.
(Msg. 2) Posted: Mon May 12, 2008 12:16 am
Post subject: Re: Selecting a particular column [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
For that many lines, Alt+Drag to column select would be chancy. I'd replace
each space with a tab character, then convert the text to a table,
separating at tabs. Delete the second column, convert the first back to
text, and then select.
There are intermediate possibilities: you could skip the replace and just
create the table, directly, separating at spaces; you could select the first
column and paste into another document, then convert to text and copy/paste
into Notepad or whatever. If you're pasting into Excel, you can just select
the first column of the table and copy/paste directly (Excel understands
tables). But that's the general approach.
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"Vishwas Upadhyaya" <vishwas.uk RemoveThis @gmail.com> wrote in message
news:298360d8-2522-4c68-864a-18c2a7acfb0a@r66g2000hsg.googlegroups.com...
> 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
(Msg. 3) Posted: Mon May 12, 2008 10:59 am
Post subject: Re: Selecting a particular column [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
On May 12, 4:47 am, "Doug Robbins - Word MVP"
<d....TakeThisOut@REMOVECAPSmvps.org> 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....TakeThisOut@gmail.com> wrote in message
>
> news:298360d8-2522-4c68-864a-18c2a7acfb0a@r66g2000hsg.googlegroups.com...
>
>
>
> > 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.
(Msg. 4) Posted: Mon May 12, 2008 11:23 am
Post subject: Re: Selecting a particular column [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
On May 12, 12:16 am, "Suzanne S. Barnhill" <sbarnh....DeleteThis@mvps.org> wrote:
> For that many lines, Alt+Drag to column select would be chancy. I'd replace
> each space with a tab character, then convert the text to a table,
> separating at tabs. Delete the second column, convert the first back to
> text, and then select.
>
> There are intermediate possibilities: you could skip the replace and just
> create the table, directly, separating at spaces; you could select the first
> column and paste into another document, then convert to text and copy/paste
> into Notepad or whatever. If you're pasting into Excel, you can just select
> the first column of the table and copy/paste directly (Excel understands
> tables). But that's the general approach.
>
> --
> Suzanne S. Barnhill
> Microsoft MVP (Word)
> Words into Type
> Fairhope, Alabama USA
>
> "Vishwas Upadhyaya" <vishwas....DeleteThis@gmail.com> wrote in message
>
> news:298360d8-2522-4c68-864a-18c2a7acfb0a@r66g2000hsg.googlegroups.com...
>
>
>
> > 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 -
This works!! Although its kind of lengthy it works really well. I
used "convert the text to a table" with seperating character specified
as 'space' typed in "other" category. Thanks a million!!
(Msg. 5) Posted: Mon May 12, 2008 7:47 pm
Post subject: Re: Selecting a particular column [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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.uk.TakeThisOut@gmail.com> wrote in message
news:298360d8-2522-4c68-864a-18c2a7acfb0a@r66g2000hsg.googlegroups.com...
> 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
(Msg. 6) Posted: Mon May 12, 2008 7:47 pm
Post subject: Re: Selecting a particular column [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Much faster than my way!
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"Doug Robbins - Word MVP" <dkr.DeleteThis@REMOVECAPSmvps.org> wrote in message
news:OvxvEVBtIHA.3680@TK2MSFTNGP05.phx.gbl...
> 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.uk.DeleteThis@gmail.com> wrote in message
> news:298360d8-2522-4c68-864a-18c2a7acfb0a@r66g2000hsg.googlegroups.com...
>> 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
>
>
>
(Msg. 7) Posted: Tue May 13, 2008 1:25 am
Post subject: Re: Selecting a particular column [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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"
> <d....DeleteThis@REMOVECAPSmvps.org> 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....DeleteThis@gmail.com> wrote in message
> >
> > news:298360d8-2522-4c68-864a-18c2a7acfb0a@r66g2000hsg.googlegroups.com...
> >
> >
> >
> > > 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
>
(Msg. 8) Posted: Tue May 13, 2008 8:17 am
Post subject: Re: Selecting a particular column [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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" <DeanH RemoveThis @discussions.microsoft.com> wrote in message
news:0831DFA0-C644-443A-8AFA-FBFF26D9FE7B@microsoft.com...
> 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"
>> <d... RemoveThis @REMOVECAPSmvps.org> 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... RemoveThis @gmail.com> wrote in message
>> >
>> > news:298360d8-2522-4c68-864a-18c2a7acfb0a@r66g2000hsg.googlegroups.com...
>> >
>> >
>> >
>> > > 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
>>
>
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office