This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a column of data where the country, firs name and last name are in the same column. I want the country in one column, the first name in another column and last name in yet another column. My problem is that some of the countries contain two words such as United States or South Africa so when I parse using a space as delimiter, it is putting United in one column and States in another. See attached Winner column.