How can i copy the values derived from find and replace?

  • Thread starter Thread starter clem
  • Start date Start date
C

clem

I need to get a number of data entries from an Excel worksheet. I did a
"find" and came up with more than 1000 values. How can I copy the values all
at the same time without doing a manual copying of each value/entry? Thanks!
 
Are the values all in the one column. If so, try using AutoFilter and then
copy the visible cells.
 
After you set up your Find, click Find All and you will get a list with the
1000 values... press Ctrl+A to select them all and then close the Find
dialog box. The 1000 items will all be selected... just Copy them, go to
some other location and Paste them in.

Rick
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find and replace a value within a formula 2
Use Find and Replace in Excel 2
Excel Help to copy information from one row at a time to another sheet 1
find the correct sum 1
derive data from masterlist to another worksheet in same workbook 2
Numbers change in cell even when formatted as text 4
Excel In Excel how can I block the contenent of a cell? 0
Create sorted list based on cell values 7

Back
Top