Hi,
I need a formula to extract cell content in a given column (words separated by spaces) to destination cell into comma separated form:
Ex: Cell (A1) George Michael into: George, Michael
or:
Cell (A2) Last Minute Opportunities Into: Last, Minute, Opportunities
in case which only one word contained in cell, it should be extracted as is.
Any help with that?
Okay.. use below formula :-
Formula:
Please Login or Register to view this content.
tested on a2 as you said above.
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
Works perfectly!
Thanks a lot Dilipandey
You are welcome...
please mark this thread as [SOLVED].. thanks.
Regards,
DILIPandey
<click on below * if this helps>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks