Every cell i have capital letters in the end, is it possible to move them to another column
Sample, like you see some times there is some lonely random letter or number and after that comes the part which i want to move another column.
<tbody>
</tbody>
Here sample how I want this
<tbody>
</tbody>
Help appreciated
BR. Petter
Sample, like you see some times there is some lonely random letter or number and after that comes the part which i want to move another column.
Juvan teollisuuskatu 15 B ESPOO |
Ollaksentie 9 A ESPOO |
Otsonkallio 2 ESPOO |
Rentukkatie 4 B 1 VANTAA |
Huopalahdentie 7 HELSINKI |
Tuulikintie 16 VANTAA |
Eilantie 37 VANTAA |
Mittalinja 5 VANTAA |
Puolarmetsänkuja 6 B ESPOO |
Elannontie 5 VANTAA |
<tbody>
</tbody>
Here sample how I want this
Juvan teollisuuskatu 15 B | ESPOO |
Ollaksentie 9 A | ESPOO |
Otsonkallio 2 | ESPOO |
Rentukkatie 4 B 1 | VANTAA |
Huopalahdentie 7 | HELSINKI |
Tuulikintie 16 | VANTAA |
Eilantie 37 | VANTAA |
Mittalinja 5 | VANTAA |
Puolarmetsänkuja 6 B | ESPOO |
Elannontie 5 | VANTAA |
<tbody>
</tbody>
Help appreciated
BR. Petter