How to find the first capital word in a cell in excel?

Y

Yrets1692022-03-20 14:47:03

excel

Yrets169, 2022-03-20 14:47:03

Good afternoon, what should be the formula, but would display a word in which there is a first capital letter?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

E

Elvis, 2022-03-20
@Yrets169

Using regular expressions
You need a regular expression like this[А-ЯЁ]([а-яё])*

Similar questions

I

Ivan Medvedev2020-03-04 08:06:16

D

Dwellss2019-09-23 15:33:22

N

newaitix2017-04-23 13:56:38

D

Dmitry Largovich2015-05-05 08:54:45

Y

Yura Storchak2019-10-04 21:36:32

Didn't find what you were looking for?