Multiple Cells data merging with comma

Dear All,

I want to merge data from multiple cells into a single cell with comma(,) separation. Please help me in this regard, any formula/function to do this? Thanks in advance.

Replies (10)

 

you can use function CONCATENATE ...

 

to add a space\comma put it in " starting and at the end.cell referrence means address of cells u want to join... 

 

=CONCATENATE(cell reference," ",cell reference)

Hello every body,

                        I want to write 1 crore in numbers as 1,00,00,000 in excel not in 10,000,000 If you know about this please tell me how it is possible.

Explained below:

in Control Panel>regional and language option>then in regional option TAB click customize

Change the Digit Grouping Style

 

 

Thanks for Sharing such useful info

hi jatinder,

the simplest thing u hav to do is

the cells should be selected-> go to format cells-> customs -> type this formula

[>=10000000]#","##","##","##0.00;[>=100000]#","##","##0.00;#,##0.00
 

 

Thanks for sharing this useful things.

Originally posted by :satya.dharani
" Dear All,
I want to merge data from multiple cells into a single cell with comma(,) separation. Please help me in this regard, any formula/function to do this? Thanks in advance.
"

 

Plz Find attached file may  be this file solve ur problm
 

Originally posted by :jatinder kumar
" Hello every body,
                        I want to write 1 crore in numbers as 1,00,00,000 in excel not in 10,000,000 If you know about this please tell me how it is possible.
"


 

 Start ---> Control Panel--> Rregional and language option--->customize---> number Tab---> Grouping Digit

 

=CELL REFRENCE&" "&CELL REFRENCE&" "&CELL REFRENCE

 Thanks to, GIRISH, Charmi Vasani, Aarti Jain 

for ur reply in this regard,



Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
16 November 2026
Indirect Tax Associate

Sekhri Kanodia & Associates

Mumbai

B.Com

View Details
Company
31 October 2026
Accountants

sankaran and krishnan

New Delhi

B.Com

View Details
Company
20 November 2026
Charted Accountant

Cothas Coffee Co.

Bengaluru

CA

View Details
Company
Featured 07 November 2026
Paid Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
Featured 17 November 2026
Chartered Accountant

M/s. A V C & Co.

New Delhi

CA

View Details
Company
12 November 2026
Tax Product Specialist

BharatX.ai

Gurgaon

B.Com

View Details
Company
Featured ARTICLESHIP 18 November 2026
Articles

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Foundation

View Details
Company
ARTICLESHIP 07 November 2026
Article Assisstant

DPV & Associates

Chennai

CA Inter

View Details