View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dickives
 
Posts: n/a
Default Fixing Comma Separated Values (.csv)


I am trying to export my bank statement to excel. The only option I
have that will work in excel is .csv. The problem is that this format
does not separate the data. It keeps it all in one cell, with commas
separating it (hence the name). For example, cell A2 contains the
date, description and amount. What I want is for date to be in A2,
description to be in B2 and amount to be in C2.

Is there an easy way to break the lines up into separate cells?
Thanks.


--
dickives
------------------------------------------------------------------------
dickives's Profile: http://www.excelforum.com/member.php...o&userid=30532
View this thread: http://www.excelforum.com/showthread...hreadid=512245