Excel Formula required for flip words - Urgent

[ctanxcel]

Hello
I want Excel Formula for below

Example: 123 South America 456 Sri Lanka 711 South Africa 167 New Zealand
into below formate
South America: 123; Sri Lanka: 456; South Africa: 711; New Zealand: 167

Thanks

 

[Fluff]

Duplicate to: Need Formula for flip words

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.