Multiple Cells data merging with comma

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.

Plz Find attached file may  be this file solve ur problm
 

 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,