Thread: Separating a string to two fields
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rowan[_6_] Rowan[_6_] is offline
external usenet poster
  
Posts: 1
Default Separating a string to two fields

With your list in Column A and nothing in Column B, select the list then
use the menus DataText To ColumnsDelimited. Check comma and space and
then click finish.

Hope this helps
Rowan


--
Rowan
------------------------------------------------------------------------
Rowan's Profile: http://www.excelforum.com/member.php...o&userid=26535
View this thread: http://www.excelforum.com/showthread...hreadid=453971

Reply With QuoteReply With Quote