how to Separate with comma in one cell
like this
Apple-5,
banana-2,
Mango-12,
watermelon-1,
papaya-4,
Grapes-12,
in one cell..
Regards,
sanjeevi
how to Separate with comma in one cell
like this
Apple-5,
banana-2,
Mango-12,
watermelon-1,
papaya-4,
Grapes-12,
in one cell..
Regards,
sanjeevi
Last edited by sanjeevi888; 06-22-2012 at 12:36 PM.
Select the cells, hit CTRL+G
Replace comma with comma and (holding the ALT key, enter 010 using Number Keypad on the right of keyboard).
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Separate words 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..
Did you try the above suggestion?
Don't repeat same question please.
From NBVC's suggestion, you open the REPLACE function with CTRL-H, not Ctrl-G.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
oops, thanks.... my faux pas!
Thanks.. U Beaucaire & NBVC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks