That did help. Thanks, Ron.
silas
"Ron Coderre" <(E-Mail Removed)> wrote in message
news:2E05D3BC-E7F1-4D26-8163-(E-Mail Removed)...
> 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" wrote:
>
>> 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
>> news:(E-Mail Removed)...
>> > 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"
>> > <(E-Mail Removed)>
>> > 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
>> >
>>
>>
|
Similar Threads
