LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Match function with duplicate values in an array Richard Excel Worksheet Functions 3 April 22nd 23 07:45 PM
Combine FREQUENCY and SUM of Associated Values MichaelC Excel Worksheet Functions 3 July 3rd 05 01:54 AM
Second serie doesn't use X-as values JackRnl Charts and Charting in Excel 1 January 20th 05 01:04 AM
.CSV file format - comma or semi-colon? bavjean Excel Worksheet Functions 5 November 12th 04 12:26 PM
.CSV file format - comma or semi-colon antifashionpimp Excel Worksheet Functions 1 November 10th 04 01:18 PM


All times are GMT +1. The time now is 03:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"