how can i extract some attributes in field to a new field in attribute table?

[PintoJoão]

Hello

I want to transfer in the TESTE field(img) only cities(strings) to a new field but but with the same numeral representation.

Ex: |1| Guimarães|; |2|Porto| ; |3|Lisboa|

Thank You an best regards