When you copy text from a website or program it automaticaly selects
all the text in that row. Is there a way to just select (for
instance)the lables down the page on the left without copying the
values on the right? I'm trying to copy some investment catagories
from a program and pasting them into Excel without all the text to the
right. Is there a way to only select verticaly? And, any other hints
in copy and pasting into Excel would be very helpful.
Thanks for the help!
Greg |
Request for Question Clarification by
pafalafa-ga
on
03 Feb 2006 16:58 PST
fallstaf-ga,
It's amazing how the seemingly simplest of tasks -- cutting and
pasting -- is still one of the most cumbersome in this hi-tech world
of ours.
There's no blanket solution that I know of, but there are an awful lot
of tricks of the trade. However, the only way to really apply them
would be to see the text in question, and try to isolate the
particular column you want.
Can you give us a link to an example of text that it of interest to you?
pafalafa-ga
|
Clarification of Question by
fallstaf-ga
on
04 Feb 2006 11:09 PST
Thanks pafalafa, I should be more specific. I'm was using a real
estate development program and it has a tutorial in Adobe format. When
I try and copy from the Adobe tutorial and paste into Excel (to play
with investment numbers etc.) the data, text and numbers, are all
stuck together. How can I copy and paste what info. I want and have it
paste into Excel in the same format as the Adobe program?
Greg
|
Request for Question Clarification by
pafalafa-ga
on
04 Feb 2006 11:37 PST
Greg,
I'd love to help you, but like I said above about the tricks of the
trade, "...the only way to really apply them would be to see the text
in question...".
Short of that, I just don't know how to help you. Sorry.
pafalafa-ga
|
Clarification of Question by
fallstaf-ga
on
04 Feb 2006 12:27 PST
Here is a sample of what i've copied of the program:
Analysis of Sale Proceeds
Sale Price (as discussed above) $5,062,520
- Costs of Sale (6%) 303,751
- Loan Balances 1,812,762
- Prepayment Penalties 0
Sale Proceeds Before Tax $2,946,007
Analysis of Capital Gain Results
Sale Price $5,062,520
- Capitalized Costs of Sale (100%) 303,751
Net Sale Price for Tax Purposes $4,758,769
Property Basis at Acquisition $0
+ Capitalized Closing Costs (100%) 0
+ Capital Additions 3,215,270
- Depreciation Taken 476,477
+ Excess Depreciation Recaptured 0
Adjusted Basis at Sale 2,738,793
Capital Gain (or Loss) $2,019,976
- Suspended
|
Request for Question Clarification by
pafalafa-ga
on
05 Feb 2006 17:36 PST
Thanks, but also...sorry!
That's a bit too messy to work with in any easy fashion. It's
possible that seeing the original PDF page that the data come from
would help, but then again, it may not!
Looks like I'll have to take a pass on this one, but best of luck.
paf
|
