Looking up a country name and copying to column 2

[Guest]

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.

 

[Bob Phillips]

Jaco,

You don't need a macro. Add this formula to B1

=MID(A1,FIND(" ",A1)+1,FIND(" ",A1,FIND(" ",A1)+1)-FIND(" ",A1)-1)

and copy down.

 

[Guest]

Bob,

I've tried this and it only shows the formula.

Jaco

 

[Bob Phillips]

Maybe your settings. Go to Tools>Options>View and make sure that Formulas is
not checked.