View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
mrsinnister
 
Posts: n/a
Default How to split a value seperated by comma?


*-Go to Data menu, and choose text to columns. If you want it kept as
you see it, choose fixed width. If you choose comma delimited, it will
assign columns for each field. Choose how you want it allocated, it
will give you a preview, if that is how you want it click FINISH.-*


--
mrsinnister
------------------------------------------------------------------------
mrsinnister's Profile: http://www.excelforum.com/member.php...o&userid=32737
View this thread: http://www.excelforum.com/showthread...hreadid=525715