Software

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.

Thread display: Collapse - | Expand +

All Comments

Related Discussions

Related Forums