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.

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.

--
HTH

Bob Phillips

"Jaco Jacobs" wrote in message
...
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,

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

Jaco

"Bob Phillips" wrote:

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.

--
HTH

Bob Phillips

"Jaco Jacobs" wrote in message
...
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.

Maybe your settings. Go to ToolsOptionsView and make sure that Formulas is
not checked.

--
HTH

Bob Phillips

"Jaco Jacobs" wrote in message
...
Bob,

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

Jaco

"Bob Phillips" wrote:

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.

--
HTH

Bob Phillips

"Jaco Jacobs" wrote in message
...
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.