Software

Ask something
Discussion Locked

Excel Questions

0 helpful
3 replies

by penguinsrule

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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 [U] 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

3 replies

by dklippert

1, Go to Data, Filter, AutoFilter
Click the down arrow by the field name and choose custom to add your criteria

2, Look up references to web queries

This discussion is closed to new replies.