Separate text with comma

[sanjeevi888]

Separate text with comma down by down

Apple-5, banana-2, Mango-12, watermelon-1, papaya-4, Grapes-12,

to change

Apple-5,
banana-2,
Mango-12,
watermelon-1,
papaya-4,
Grapes-12,

in one cell..


Regards,

Sanjeevi

[Admin]

Hi Sanjeevi,

Try

=SUBSTITUTE(D5,", ",", "&CHAR(10))

and wrap the cell.

HTH

[sanjeevi888]

code Working successfully Thank.. U bro :D

[NBVC]

Crossposted:

[SOLVED] Separate with Comma in one Cell (http://www.excelforum.com/excel-new-users/839719-separate-with-comma-in-one-cell.html)