I'm trying to figure out how to duplicate part of the content of a column (text) to another column in other sheet. For example, I have column A in Sheet1 and I want to show only a word of this column in Sheet2. Here an example file.
Google Sheets – Copy Part of Column to Another Sheet
google sheets
Related Topic
- Google-sheets – Sort column from another sheet alphabetically
- Google Sheets – Split and Transpose Text from Multiple Rows into One Column
- Google Sheets – Combine Text from Multiple Cells into Single Cell
- Google-sheets – Copy data validation “list of items” from one sheet to another
- Google-sheets – How to check separate sheet cell for any data, and return a Y
- Google-sheets – Function to copy fields from one sheet to another based on IF statements
- Google-sheets – Copy value from another column based on cell value
Best Answer
Here how to do that with a script.
Code
Explained
The range is searched by the key words in the find array. Once a word is found, the search is stopped and the next search will commence. You can add more key words in the var find array.
Note
The order of key words is very important. Better is to choose unique key words, like:
All is of course dependent upon the data available.
Example
I've added the script (Tools>Script editor) and the
ARRAYFORMULA
version of the solution Punchlinern provided in your example file.