Getting Concatenated Cell values

[nithinkm]

Hi

My scenario is that i need to get the concatenated values from cell A1 to G1 in a row (values are strings). The purpose is to insert those values in to db. Is der any excel function for that. Or i hav to use user defined function for that.

Please help me

 

[DonkeyOte]

=A1&","&B1&","&C1&","&D1&","&E1&","&F1&","&G1

or see CONCATENATE function

=CONCATENATE(A1,",",B1,",",C1,",",D1,",",E1,",",F1,",",G1)

obviously change "," to another delimiter if so desired.

 

[nithinkm]

Thanks laws10 for the reply

One more thing i need to know is should i specify a Range instead of giving A1,B1........G1 in concatenate function

Thanks again
Regards
Nithin

 

[DonkeyOte]

Alas not without a custom function - either building yourself or using an additional add-in such as MOREFUNC.xla (which has MCONCAT function)

 

[nithinkm]

Thanks laws10, thank you very much
I have got a link and is wrking http://www.vbaexpress.com/kb/getarticle.php?kb_id=817
Regards
Nithin