Email ID Consolidate by adding , comma

[Nitin Shardul]

Hi,

How can i add , (comma) & conslidate the same in single row
attached sample file for reference

Thanks

 

[Naresh Yadav]

Dear Nitin,

pls check here..

http://chandoo.org/wp/2014/01/13/combine-text-values-quick-tip/

 

[deciog]

Nitin Shardul

If Excel 2016 using this formula

Décio

 

[xlstime]

Hi Nitin,

Enclosed solution without VBA and with VBA

Hi,

How can i add , (comma) & conslidate the same in single row
attached sample file for reference

Thanks

 

[Nitin Shardul]

Great Thank you So much