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

W

weranda2017-06-01 22:20:41

Z

zhaar2019-11-07 17:26:14

B

bizex2021-05-05 12:15:12

S

sunekosuri2021-05-06 15:28:50

V

Vladislav2017-06-10 14:11:49

Didn't find what you were looking for?