I have two column one containing Country Codes, and another one conataining
Dial Codes, in Dial Codes Column you can find one Cell contains many Dial
Codes separated by Commas, which is amount of dial codes is very depndable on
the Contry Numbering Plan. the Question is; is there any formular I can use
to insert Country Code infornt of each Dial code that are separated with
commas???

thank you.

Maybe you can use a column of formulas that look like:

="1" & a1

(where A1 contains the phone number)

Then drag down the column.

wise_man wrote:

I have two column one containing Country Codes, and another one conataining
Dial Codes, in Dial Codes Column you can find one Cell contains many Dial
Codes separated by Commas, which is amount of dial codes is very depndable on
the Contry Numbering Plan. the Question is; is there any formular I can use
to insert Country Code infornt of each Dial code that are separated with
commas???

thank you.

--

Dave Peterson