O
O
Old_disciple2021-09-29 11:47:09
Google Apps Script
Old_disciple, 2021-09-29 11:47:09

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

1 answer(s)
G
Grigory Boev, 2021-10-28
@ProgrammerForever

=REGEXEXTRACT(a1;"(.*?)\s")

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question