If the country code is in A1 and the comma-separated dialling codes in B1,
then
=A1&SUBSTITUTE(B1,",",","&A1)
in C1 will do what you ask. E.g. if A1 contains 49 and B1 211,221,228,30,69
, then C1 will display 49211,49221,49228,4930,4969. Be careful about your
thousand separators.

--
Noel

"wise_man" wrote in message
...
Dear Team,

I remember you help me out my keen questions few month back, which I
really
apriaciate for that, but now I come with another question, I have two
columns
one is containg Country Codes (one cell one contry code) and the other
Column
containingg Dial codes, in which you can find too many dial codes in one
Cell, this is very dependable on its Country Numbering Plan. However all
dial codes are separated with commas. Consequently, my question is there
any
formular I can use to take Contry codes from one Column and add infornt of
each Dial code in another Column that are separated by Commas??? It has
been
difficult to me to use CONCATENATE since there is too many Dial codes in
one
Cell and all are separated with Commas. What I'm doing Currently is
adding
mannually, which the task has become tidious and time consume.

thank you in adavance for your help.