General discussion

Locked

Excel Questions

By PENGUINSRULE ·
Hi

I have some questions concerning Excel
1) Let's say I have a document with 7000 Records, and I want to look at/copy/etc only the records that contain a particular character string (In my particular case I only want to view the records that contain How in Excel or Windows do I do this? I am familiar with VMS and VMS has a utility where you can do something like this. ..
2) On the Web I often find spreadsheets posted on web sites, but when I try to download the sheet, it just saves it as a web page and when I try to copy it into Excel, it just copies the entire block into one Column, but I don't really want it that way, I want it to break it up into columns, else I have to do a ton of work to try to reformat the whole 10000 row spreadsheet. Is there any way of doing this easily?

Thanks

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums