After digging around the forum, I found the solution to this problem by user

sweep
http://www.excelforum.com/showthread...=extract+comma