How to sort text in Google Sheets?

P

pvshvb2022-03-02 15:10:53

excel

pvshvb, 2022-03-02 15:10:53

There are many lines with content of this type "front right headlight for Volkswagen Polo sedan pos"
The task is to leave in it only words starting with capital letters, how to do this?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

E

Elvis, 2022-03-02
@pvshvb

=TRIM(REGEXREPLACE(A1;"(^|\s|\b)+[^A-ZА-ЯЁ ]+"; ""))

The regular expression in REGEXREPLACE looks for NOT capitalized words and replaces them with empty space. TRIM removes extra spaces.

Similar questions

I

ilya u2016-05-25 06:21:24

Excel: how to find and replace a large chunk if a cell has more than 10000 characters? 1Reply

N

Nastushik2020-09-09 21:10:06

How to import tables on each new sheet of an excel book and, when re-importing, if the numbers match, add a line where the numbers match? 0Reply

A

Alexey Smirnov2014-04-12 22:19:26

How to extract text data from Google Docs Excel cells to the site? 0Reply

A

Arsen Asatryan2020-09-10 19:48:22

Group properties into 1 excel cell. Is it possible? 1Reply

I

Ivan Wagner2018-11-04 18:26:15

How to arrange numbers in a certain order? 1Reply

Didn't find what you were looking for?

Ask your question