| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking up a country name and copying to column 2
I have a spreadsheet and in column A there is a list like this
LBYBNKLTD Libya BN.KLT.DINV.CD Foreign direct investment, net (BoP, current US$) The second word in is always a country and changes. I would like to know if there is a macro and what would the macro be to look up the name of the country (That will always be the same ammount of characters in) and paste the name of the country into column B. There are 3600 rows in the spreadsheet. Hope anyone can help with this. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to sum the 3 best scores for every country in an contest? | Excel Worksheet Functions | |||
| typing 'Up Country' ends up as Up Country' ? | Excel Discussion (Misc queries) | |||
| Show Country Name at Each Row | Excel Worksheet Functions | |||
| Show Country Name in Each Row | Excel Worksheet Functions | |||
| country list | Excel Discussion (Misc queries) | |||
Threaded Mode
