I want to convert data into perticular formate. Below are the example
Examples:
Cell A1 "1232 india 445 United States 468 United Kingdom 96 United Arab Emirates"
Into this format
Cell A1 "India: 1232; US: 445; UK: 468; UAE: 96;"
Examples:
Cell A1 "1232 india 445 United States 468 United Kingdom 96 United Arab Emirates"
Into this format
Cell A1 "India: 1232; US: 445; UK: 468; UAE: 96;"