1. Convert 1 space into 100 space.
2. The result is shown in the figure, = substitute (a2, "",rept (",100)).
Note that there is a space between the two sets of quotation marks in the formula.
REPT (",100) means to repeat" "one hundred times.
After the replacement, we found that the original place separated by a space became a long blank, but actually the middle became 100 spaces.
In that case, we can count from the right.
3. Set another formula right in front.
=RIGHT (replace (A2, "",REPT ("",100)), 50)
Take 50 characters to the right, and the general address shall not exceed 50 characters.
There must be many spaces in the 50 words taken out here. To be more perfect, we can remove spaces.
Put a pruning formula in front of it.
=TRIM(RIGHT (replace (A2, "",REPT ("",100)), 50))
This is basically perfect.