Go Ad-Free on CAclubindia with Daily Mobile Updates. Subscribe Now!

Multiple Cells data merging with comma

satya (Executive Excise) (1839 Points)

27 November 2009

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.

Reply
Follow
Share

10 Replies

CA GIRISH (Chartered Accountant) (1796 Points)
Replied 27 November 2009

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)

1 Like

Upgrade to CAclubindia Pro. Subscribe Now!

jatinder kumar (accountant) (27 Points)
Replied 27 November 2009

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.

Rajender Kumar (Accounts Officer) (25 Points)
Replied 28 November 2009

Explained below:

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

Change the Digit Grouping Style

CA Manasa (CA) (1479 Points)
Replied 28 November 2009

Thanks for Sharing such useful info

KAUSHAL MADHOGARIA (Future CA, B Com.) (43 Points)
Replied 28 November 2009

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

Upgrade to CAclubindia Pro. Subscribe Now!

L KANAGARAJ (Assistant Manager-Finance) (615 Points)
Replied 28 November 2009

Thanks for sharing this useful things.

(Guest)

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

Attached File : 48 merger cell.xls downloaded: 276 times

(Guest)

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.	"