Without code look at Data - Text To Columns

With Code look at the Split Function...
--
HTH...

Jim Thomlinson


"wliong" wrote:


Hi everyone,

Can I separate several words that is joined by comma?
for example:
Column A -- word1, word2, word3, word4

Is there any way to make it
Column B -- word1
Column C -- word2
Column D -- word3
Column E -- word4

Thank you very much. I really really appreciate your help.


--
wliong
------------------------------------------------------------------------
wliong's Profile: http://www.excelforum.com/member.php...o&userid=28343
View this thread: http://www.excelforum.com/showthread...hreadid=493982