Insert Hyphen (-) between two words

Hi,

I have big list of Country and Currency codes. Is there a way to insert a Hyphen (-) between the two words.


Eg:

Afghanistan Afghani
Albanian Lek
Algerian Dinar
Andorran Franc
Andorran Peseta
Angolan Kwanza


Thanks
R

Hi,

Are the words in separate cells on the spreadsheet? If so, you just need to use the following formula:

PHP Code: 

=A2&"-"&B2 


where A2 is the cell with the country and B2 is the cell with the currency.


If these two pieces of information are in the same cell, you're going to have more difficulties. In general, there will only be one space between the two words, which would make it easy. However, occasionally you'll have a situation where one or the other has more, such as "New Zealand Dollar" or "China Yuan Renminbi". For this reason, there's no systematic way to determine where the dash should go.

If this is the situation you are in, I would recommend the following formula:

PHP Code: 

=IF(LEN(A2)-SUBSTITUTE(A2," ","")>1,"Do Manually",SUBSTITUTE(A2," ","-")) 


where A2 is the cell that has the country/currency information.

In this formula, it would do all the easy ones. You would then have to go through and look at the "Do Manually" ones and make the determination for yourself.

S

thank you so much.