| |
| |||||||
| Windows XP Discuss the Microsoft Windows XP Operating System |
 |
| | LinkBack | Thread Tools |
09-19-2007, 02:00 AM
| |||
| |||
| Cutting and pasting multiple lines in Excel Apologies if this is in the wrong area. I've downloaded some .csv files which contain speed camera details for my Garmin Zumo. There are separate files for Average, Mobile and Gatso cameras, among others. The Gatso file (for example) lists all know Gatsos, and identifies them with the speed in the last cell on each line (i.e 30 - 40 - 50) but the lines are not all in groups of each speed, there may be three 30s, then two 40s, then six more 30s etc. I want to be able to select all of the lines for one speed and save them into another new file, thus ending up with a 30 file, a 40 file, a 50 file... etc. Excel (2003 XP) baulks at letting me select mulitple lines for a cut or copy operation, and cutting and pasting each line individually is out of the question as there are over 5000 in each of the four original files. Can it be done?      |
|
09-19-2007, 02:00 AM
| ||
| |
|
09-19-2007, 02:00 AM
| |||
| |||
| Re: Cutting and pasting multiple lines in Excel "Martin Ellis" <MartinEllis@discussions.microsoft.com> wrote in message news:2126E2B5-7962-41E2-9EFD-78D3710BED2B@microsoft.com... > Apologies if this is in the wrong area. > I'm afraid you are. An Excel newsgroup would be the right place to post your question. |
|
09-19-2007, 02:00 AM
| |||
| |||
| Re: Cutting and pasting multiple lines in Excel "Martin Ellis" <MartinEllis@discussions.microsoft.com> wrote in message news:2126E2B5-7962-41E2-9EFD-78D3710BED2B@microsoft.com... > Apologies if this is in the wrong area. > I'm afraid you are. An Excel newsgroup would be the right place to post your question. |
|
09-19-2007, 02:00 AM
| |||
| |||
| Re: Cutting and pasting multiple lines in Excel "Martin Ellis" <MartinEllis@discussions.microsoft.com> wrote in message news:2126E2B5-7962-41E2-9EFD-78D3710BED2B@microsoft.com... > Apologies if this is in the wrong area. > I'm afraid you are. An Excel newsgroup would be the right place to post your question. |
|
09-19-2007, 02:00 AM
| |||
| |||
| Re: Cutting and pasting multiple lines in Excel "Martin Ellis" <MartinEllis@discussions.microsoft.com> wrote in message news:2126E2B5-7962-41E2-9EFD-78D3710BED2B@microsoft.com... > Apologies if this is in the wrong area. > I'm afraid you are. An Excel newsgroup would be the right place to post your question. |
|
09-19-2007, 02:01 AM
| |||
| |||
| Re: Cutting and pasting multiple lines in Excel Fair comment. I couldn't see one in the list of available news groups on the XP page. Any ideas? "Pegasus (MVP)" wrote: > > "Martin Ellis" <MartinEllis@discussions.microsoft.com> wrote in message > news:2126E2B5-7962-41E2-9EFD-78D3710BED2B@microsoft.com... > > Apologies if this is in the wrong area. > > > > I'm afraid you are. An Excel newsgroup would be the right > place to post your question. > > > |
|
09-19-2007, 02:01 AM
| |||
| |||
| Re: Cutting and pasting multiple lines in Excel Fair comment. I couldn't see one in the list of available news groups on the XP page. Any ideas? "Pegasus (MVP)" wrote: > > "Martin Ellis" <MartinEllis@discussions.microsoft.com> wrote in message > news:2126E2B5-7962-41E2-9EFD-78D3710BED2B@microsoft.com... > > Apologies if this is in the wrong area. > > > > I'm afraid you are. An Excel newsgroup would be the right > place to post your question. > > > |
|
09-19-2007, 02:01 AM
| |||
| |||
| Re: Cutting and pasting multiple lines in Excel Fair comment. I couldn't see one in the list of available news groups on the XP page. Any ideas? "Pegasus (MVP)" wrote: > > "Martin Ellis" <MartinEllis@discussions.microsoft.com> wrote in message > news:2126E2B5-7962-41E2-9EFD-78D3710BED2B@microsoft.com... > > Apologies if this is in the wrong area. > > > > I'm afraid you are. An Excel newsgroup would be the right > place to post your question. > > > |
|
09-19-2007, 02:01 AM
| |||
| |||
| Re: Cutting and pasting multiple lines in Excel Fair comment. I couldn't see one in the list of available news groups on the XP page. Any ideas? "Pegasus (MVP)" wrote: > > "Martin Ellis" <MartinEllis@discussions.microsoft.com> wrote in message > news:2126E2B5-7962-41E2-9EFD-78D3710BED2B@microsoft.com... > > Apologies if this is in the wrong area. > > > > I'm afraid you are. An Excel newsgroup would be the right > place to post your question. > > > |
|
09-19-2007, 02:01 AM
| |||
| |||
| Re: Cutting and pasting multiple lines in Excel You should use microsoft.public.excel or microsoft.public.excel.misc Which "XP page" are you talking about? Excel will run under different versions of Windows, so "XP" is irrelevant to your needs. Stephen "Martin Ellis" <MartinEllis@discussions.microsoft.com> wrote in message news:5100ADC1-798D-4EDB-83F9-030E93878D20@microsoft.com... > Fair comment. I couldn't see one in the list of available news groups on > the > XP page. Any ideas? > > "Pegasus (MVP)" wrote: > >> >> "Martin Ellis" <MartinEllis@discussions.microsoft.com> wrote in message >> news:2126E2B5-7962-41E2-9EFD-78D3710BED2B@microsoft.com... >> > Apologies if this is in the wrong area. >> > >> >> I'm afraid you are. An Excel newsgroup would be the right >> place to post your question. >> >> >> |
|
09-19-2007, 02:01 AM
| |||
| |||
| Re: Cutting and pasting multiple lines in Excel You should use microsoft.public.excel or microsoft.public.excel.misc Which "XP page" are you talking about? Excel will run under different versions of Windows, so "XP" is irrelevant to your needs. Stephen "Martin Ellis" <MartinEllis@discussions.microsoft.com> wrote in message news:5100ADC1-798D-4EDB-83F9-030E93878D20@microsoft.com... > Fair comment. I couldn't see one in the list of available news groups on > the > XP page. Any ideas? > > "Pegasus (MVP)" wrote: > >> >> "Martin Ellis" <MartinEllis@discussions.microsoft.com> wrote in message >> news:2126E2B5-7962-41E2-9EFD-78D3710BED2B@microsoft.com... >> > Apologies if this is in the wrong area. >> > >> >> I'm afraid you are. An Excel newsgroup would be the right >> place to post your question. >> >> >> |
|
09-19-2007, 02:01 AM
| |||
| |||
| Re: Cutting and pasting multiple lines in Excel You should use microsoft.public.excel or microsoft.public.excel.misc Which "XP page" are you talking about? Excel will run under different versions of Windows, so "XP" is irrelevant to your needs. Stephen "Martin Ellis" <MartinEllis@discussions.microsoft.com> wrote in message news:5100ADC1-798D-4EDB-83F9-030E93878D20@microsoft.com... > Fair comment. I couldn't see one in the list of available news groups on > the > XP page. Any ideas? > > "Pegasus (MVP)" wrote: > >> >> "Martin Ellis" <MartinEllis@discussions.microsoft.com> wrote in message >> news:2126E2B5-7962-41E2-9EFD-78D3710BED2B@microsoft.com... >> > Apologies if this is in the wrong area. >> > >> >> I'm afraid you are. An Excel newsgroup would be the right >> place to post your question. >> >> >> |
|
09-19-2007, 02:01 AM
| |||
| |||
| Re: Cutting and pasting multiple lines in Excel You should use microsoft.public.excel or microsoft.public.excel.misc Which "XP page" are you talking about? Excel will run under different versions of Windows, so "XP" is irrelevant to your needs. Stephen "Martin Ellis" <MartinEllis@discussions.microsoft.com> wrote in message news:5100ADC1-798D-4EDB-83F9-030E93878D20@microsoft.com... > Fair comment. I couldn't see one in the list of available news groups on > the > XP page. Any ideas? > > "Pegasus (MVP)" wrote: > >> >> "Martin Ellis" <MartinEllis@discussions.microsoft.com> wrote in message >> news:2126E2B5-7962-41E2-9EFD-78D3710BED2B@microsoft.com... >> > Apologies if this is in the wrong area. >> > >> >> I'm afraid you are. An Excel newsgroup would be the right >> place to post your question. >> >> >> |
|
09-19-2007, 02:02 AM
| |||
| |||
| Re: Cutting and pasting multiple lines in Excel Martin Ellis wrote: > Fair comment. I couldn't see one in the list of available news groups > on the XP page. Any ideas? There are 31 "excel" related newsgroups on the microsoft news server. |
|
09-19-2007, 02:02 AM
| |||
| |||
| Re: Cutting and pasting multiple lines in Excel Martin Ellis wrote: > Fair comment. I couldn't see one in the list of available news groups > on the XP page. Any ideas? There are 31 "excel" related newsgroups on the microsoft news server. |
|
| Bookmarks |
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| changing line colors when cutting & pasting? | Harlett O'Dowd | Microsoft Office | 0 | 04-20-2007 10:01 AM |
| Pasting web pages causes casuses excel and word to lock-up | BillS | Microsoft Office | 0 | 04-15-2007 06:15 PM |
| Pasting excel tables into outlook | YouBetcha | Microsoft OneNote | 0 | 03-27-2007 05:01 PM |
| Pasting from access to excel 2000 to 2003 | troy stud | Microsoft Office | 3 | 01-15-2007 11:20 AM |
| Multiple lines for Section Tabs | Ed | Microsoft OneNote | 4 | 01-07-2007 12:19 AM |
| New To Technology Questions? | Do You Need Help with Your Computer or Device? | Do You Need Help with this site? |
