Answer the question
In order to leave comments, you need to log in
How to automatically copy one word into a separate cell in Google Sheets?
How to automatically copy one word into a separate cell in Google Sheets?
The meaning is this:
in column A, in cell A1 there is the text "Red orange grows on the slopes of Mount Everest"
in column A, in cell A2 there is the text "Black orange grows on the slopes of Mount Everest"
in column A, in cell A3 there is text "Red orange grows on the slopes of Mount Everest"
The task is to automatically copy the word "Red" into column B opposite each cell.
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question