- Joined
- May 7, 2012
- Messages
- 3
- Reaction score
- 0
I have a large spreadsheet where I need to search Column B for any cell containing the word "County" and if a cell is found, move that cell over to Column A. The spreadsheet has more than 10,000 rows, so I don't relish the thought of doing this manually.
The cells I am pulling out have more than just the one word. Example:
Column B contents: County: MOUNTRAIL State: ND
The recurring word is "County". Any cell in Column B needs to be moved to Column A without comprimising the rest of the document.
Any suggestions?
Thanks!
The cells I am pulling out have more than just the one word. Example:
Column B contents: County: MOUNTRAIL State: ND
The recurring word is "County". Any cell in Column B needs to be moved to Column A without comprimising the rest of the document.
Any suggestions?
Thanks!