M
M
Max2022-02-27 15:23:21
Regular Expressions
Max, 2022-02-27 15:23:21

How to break sticky sentences with regular expressions? wordWord -> word. Word?

There is text, but in it some sentences stuck together with the following:
Beginning middle end tsN beginning middle end

In fact, the task is to find words using regular expressions in the middle of which there is an uppercase character. And before it insert a dot and a space

Answer the question

In order to leave comments, you need to log in

2 answer(s)
G
Grigory Boev, 2022-02-27
@jjsf

=REGEXREPLACE(A1;"([а-яё])([А-ЯЁ])";"$1. $2")
Demo table

S
SOTVM, 2022-02-27
@sotvm

find [a-za-z ]+([A-ZA-Z][a-za-z]+[^\s])
replace dot space $1

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question