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

D

dao82019-06-19 11:48:07

E

eldar_web2015-01-28 13:47:42

S

serheg2015-02-01 02:15:50

P

Pasha_oo2017-02-13 12:15:52

V

Viktor S2021-02-16 23:55:21

Didn't find what you were looking for?