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
Printable View
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
Hi Sanjeevi,
Try
=SUBSTITUTE(D5,", ",", "&CHAR(10))
and wrap the cell.
HTH
code Working successfully Thank.. U bro :D
Crossposted:
[SOLVED] Separate with Comma in one Cell