Wondering if this is possible. I have a spreadsheet of 40k entries. Basically names and addresses of property owners. I would like to be able to search for a certain word (in this case "Heir") throughout the spreadsheet and be able to find every line containing that word and place it in a separate spreadsheet. Is this even possible? It would be awesome to be able to sort like this.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Need help scrubbing a spreadsheet
- Thread starter PSpence
- Start date
Excel Facts
Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
kevin9999
Well-known Member
- Joined
- Aug 28, 2020
- Messages
- 3,723
- Office Version
- 365
- Platform
- Windows
Are you still looking for assistance with this, or have you found a solution?Wondering if this is possible. I have a spreadsheet of 40k entries. Basically names and addresses of property owners. I would like to be able to search for a certain word (in this case "Heir") throughout the spreadsheet and be able to find every line containing that word and place it in a separate spreadsheet. Is this even possible? It would be awesome to be able to sort like this.
Upvote
0
Similar threads
- Replies
- 3
- Views
- 526
- Replies
- 0
- Views
- 126
- Question
- Replies
- 5
- Views
- 347
