A help in Excel a question

%3CLINGO-SUB%20id%3D%22lingo-sub-3244590%22%20slang%3D%22en-US%22%3EA%20help%20in%20Excel%20a%20question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3244590%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20Sir%2FMadam%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20convert%20the%20whole%20countries%20into%20continents%2C%20I%20had%20a%20question%20with%20all%20the%20countries%20in%20the%20column%2C%20and%20in%20the%20next%20column%20I%20need%20to%20but%20each%20country%20with%20its%20own%20continent.%3C%2FP%3E%3CP%3Ehow%20can%20I%20do%20it%20in%20Excel%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eregards%2C%3C%2FP%3E%3CP%3ERafik%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3244590%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3245044%22%20slang%3D%22en-US%22%3ERe%3A%20A%20help%20in%20Excel%20a%20question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3245044%22%20slang%3D%22en-US%22%3EOn%20another%20tab%2C%20make%20a%20list%20with%20two%20columns.%20Country%20and%20Continent.%3CBR%20%2F%3Ethen%20you%20might%20need%20to%20insert%20another%20column%20in%20you%20original%20sheet%20to%20hold%20%22continent%22%20The%20results%20in%20this%20cell%20will%20depend%20on%20the%20country.%20You%20will%20need%20to%20use%20an%20if%20statement%20to%20bring%20back%20the%20result.%20Then%20you%20can%20just%20hid%20you%20original%20column%20with%20countries.%3C%2FLINGO-BODY%3E
Occasional Visitor

Dear Sir/Madam

I am trying to convert the whole countries into continents, I had a question with all the countries in the column, and in the next column I need to but each country with its own continent.

how can I do it in Excel? 

 

regards,

Rafik

1 Reply
On another tab, make a list with two columns. Country and Continent.
then you might need to insert another column in you original sheet to hold "continent" The results in this cell will depend on the country. You will need to use an if statement to bring back the result. Then you can just hid you original column with countries.