Ron Coderre said:Try something like this:
Select the cells under the column headings, beginning with the first data
cell
From the Excel main menu:
<data><text-to-columns>
Check: Delimited.....click [next]
Check: Other...enter a dollar sign ($) in the box.....click [finish]
(that will put the amounts in the next 2 columns)
Insert a column before the amounts
Select the cells under the column headings(again), beginning with the
first
data cell
<data><text-to-columns>
Check: Fixed Width.....click [next]
Put a break point right after the date (it may already be there).....click
[finish]
(that will put the description into the column you inserted)
Is that something you can work with?
***********
Regards,
Ron
XL2002, WinXP
silas said:Gord,
The data is my account info copied from my bank's site. It's arranged in
four columns; Date, Transaction, Amount and Balance. When I copy and
paste
it into Excel it all goes into the first column. I need to be able to
separate the data into the appropriate columns.
I appreciate your assistance.
Below is a sample of six transactions.
DATE TRANSACTION AMOUNT BALANCE
03/09/2007 CHECKCARD 0308 WAL MART PITTSVILLE GA 6306112002544500 $334.68
$2,403.99
03/08/2007 CASTLE CO DES INS PREM ID 77598426 EFF DATE 070308 $156.00
$2,688.67
03/08/2007 Check 5128 $389.91 $3,004.67
03/07/2007 Monthly Maintenance Fee $117.00 $3,106.58
03/07/2007 CHECKCARD 0306 PITTSVILLE FOODS INC #566 355683321005460
$585.05
$3,541.58
03/07/2007 MATRIX WIRELES DES PYMT ID 6303210890 EFF DATE 070307 $479.22
$2,909.63
silas
Does your bank have the option of downloading a csv file??silas said:That did help. Thanks, Ron.
silas
Ron Coderre said:Try something like this:
Select the cells under the column headings, beginning with the first data
cell
From the Excel main menu:
<data><text-to-columns>
Check: Delimited.....click [next]
Check: Other...enter a dollar sign ($) in the box.....click [finish]
(that will put the amounts in the next 2 columns)
Insert a column before the amounts
Select the cells under the column headings(again), beginning with the
first
data cell
<data><text-to-columns>
Check: Fixed Width.....click [next]
Put a break point right after the date (it may already be
there).....click
[finish]
(that will put the description into the column you inserted)
Is that something you can work with?
***********
Regards,
Ron
XL2002, WinXP
silas said:Gord,
The data is my account info copied from my bank's site. It's arranged in
four columns; Date, Transaction, Amount and Balance. When I copy and
paste
it into Excel it all goes into the first column. I need to be able to
separate the data into the appropriate columns.
I appreciate your assistance.
Below is a sample of six transactions.
DATE TRANSACTION AMOUNT BALANCE
03/09/2007 CHECKCARD 0308 WAL MART PITTSVILLE GA 6306112002544500
$334.68
$2,403.99
03/08/2007 CASTLE CO DES INS PREM ID 77598426 EFF DATE 070308 $156.00
$2,688.67
03/08/2007 Check 5128 $389.91 $3,004.67
03/07/2007 Monthly Maintenance Fee $117.00 $3,106.58
03/07/2007 CHECKCARD 0306 PITTSVILLE FOODS INC #566 355683321005460
$585.05
$3,541.58
03/07/2007 MATRIX WIRELES DES PYMT ID 6303210890 EFF DATE 070307
$479.22
$2,909.63
silas
"Gord Dibben" <gorddibbATshawDOTca> wrote in message
silas
There are various methods.....worksheet functions or macros.
If we had a representative sample of your data layout and what you
want
done
with it we could make a better decision.
Gord Dibben MS Excel MVP
On Sat, 10 Mar 2007 15:32:23 -0600, "silas"
<[email protected]>
wrote:
I have rows of text and figures that I need to separate into columns.
Excel
2003 will only let me do one row at a time. Is there an add-on that
will
allow me to convert multiple rows?
Thanks.
silas
ted msn said:Does your bank have the option of downloading a csv file??silas said:That did help. Thanks, Ron.
silas
Ron Coderre said:Try something like this:
Select the cells under the column headings, beginning with the first
data cell
From the Excel main menu:
<data><text-to-columns>
Check: Delimited.....click [next]
Check: Other...enter a dollar sign ($) in the box.....click [finish]
(that will put the amounts in the next 2 columns)
Insert a column before the amounts
Select the cells under the column headings(again), beginning with the
first
data cell
<data><text-to-columns>
Check: Fixed Width.....click [next]
Put a break point right after the date (it may already be
there).....click
[finish]
(that will put the description into the column you inserted)
Is that something you can work with?
***********
Regards,
Ron
XL2002, WinXP
:
Gord,
The data is my account info copied from my bank's site. It's arranged
in
four columns; Date, Transaction, Amount and Balance. When I copy and
paste
it into Excel it all goes into the first column. I need to be able to
separate the data into the appropriate columns.
I appreciate your assistance.
Below is a sample of six transactions.
DATE TRANSACTION AMOUNT BALANCE
03/09/2007 CHECKCARD 0308 WAL MART PITTSVILLE GA 6306112002544500
$334.68
$2,403.99
03/08/2007 CASTLE CO DES INS PREM ID 77598426 EFF DATE 070308 $156.00
$2,688.67
03/08/2007 Check 5128 $389.91 $3,004.67
03/07/2007 Monthly Maintenance Fee $117.00 $3,106.58
03/07/2007 CHECKCARD 0306 PITTSVILLE FOODS INC #566 355683321005460
$585.05
$3,541.58
03/07/2007 MATRIX WIRELES DES PYMT ID 6303210890 EFF DATE 070307
$479.22
$2,909.63
silas
"Gord Dibben" <gorddibbATshawDOTca> wrote in message
silas
There are various methods.....worksheet functions or macros.
If we had a representative sample of your data layout and what you
want
done
with it we could make a better decision.
Gord Dibben MS Excel MVP
On Sat, 10 Mar 2007 15:32:23 -0600, "silas"
<[email protected]>
wrote:
I have rows of text and figures that I need to separate into columns.
Excel
2003 will only let me do one row at a time. Is there an add-on that
will
allow me to convert multiple rows?
Thanks.
silas
regards
ted