How to divide the cell into two, so that instead of "Yuri Suyunchaliev street No. 16v" it would turn out "Yuri Suyunchaliev street" and "16v"?

Question

excel

How to divide the cell into two, so that instead of "Yuri Suyunchaliev street No. 16v" it would turn out "Yuri Suyunchaliev street" and "16v"?

Answer 1

Is there always a number?
Then
first cell:
second cell:
=ПРАВСИМВ(C6;ДЛСТР(C6)-ПОИСК("№";C6))

Answer 2

By the way, if there is always a number, then you can text by columns - with a separator - specify the separator number