How to split an Excel cell?

Question

excel

In an excel table, cells contain numbers with words without spaces:
.
How to split into 2 different cells without losing value?

Answer 1

Good afternoon!
As you can see from your example, the left side is the numbers, which are always five. You can use the formula Levsymv (Your line, 5) - get the numbers. To get the last name - RIGHT (Your string; DLSTR (Your string) -5)

Answer 2

You can also write a macro in vba if you allow the use of macros in a document. The logic is simple: if it’s really the first 5 characters of a digit, then cut off the first and insert it into column B, the rest into column C. If the number of digits is always different, then you can first take only numbers with regular expressions, then only letters, or determine which character is the first not digit, etc.