I frequently copy a formula to another cell so that I can see just the
formula. What I do is (usually in the formula bar) highlight the entire
formula except for the = sign. Then I hit cntl-c to copy (and you have to do
something like either hit enter to accept the formula or escape to get out of
it before moving to the cell you want to copy it to. I frequently forget this
step and excel thinks I want to make the cell I am trying to copy to part of
the current formula.)
Then of course, select the cell you want the text part of the formula in and
paste (I just hit cntl-v)
As for pasting part of a formula into another formula, that does work, but
sometimes I have problems with that also. What I tried just now that seems
to work most consistently for me is (and I am using Excell 2000 also,) copy
the formula into the Office Clipboard (for instance by hitting cntl-c twice.)
Then go to the formula bar of the formula that you want to copy this formula
into, position your cursor, and then choose the formula from the office
clipboard (by pointing to it and left-clicking)
If anyone else knows a better or more reliable way to consistently copy a
formula into another formula, I too would appreciate knowing what it is.
"Starchaser" wrote:
I am trying to help someone with some converting of data in Excel files
so they can be used in a db. She has long columns of names with first,
int., last, jr, and even (maiden names) - all in one cell. She has
Office 2000. I'm new to Excel, and it's been 8 years since I did any
macro writing in Lotus even, so I would appreciate any help.
When I write a formula, I find it is easier to do it in little pieces,
one formulae at a time. I want to be able to have one column with a
formulae in it and the next column or a separate window showing that
same formulae in text format. For example: =LEFT(A8,FIND(" ",A8)) in
one cell as a formula
and the same LEFT(A8,FIND(" ",A8)) in text, so that I can see both how
the actual formula works and how it is written.
I have searched here, but nothing comes up.
Second question: I have tried to paste one formula into another and
Excel 2000 isn't letting me. What am I not doing or doing wrong?
FYI,yYears ago, I used a nesting macro that allowed me to build up a
complex formula by putting each individual formulae on a separate line,
thus making sure that the individual formulae gave me the result that I
was looking for. Then the macro nested the formula into one another.
It was fast and easy to build VERY complex formula with it.
Unfortunately, it was in Lotus, and I have not been able to translate
it into Excel. Here's an example of one of those formula in one cell:
60*(@INT(Input Sheet:U12)+((@INT(((Input Sheet:U12-@INT(Input
Sheet:U12))*100))+((((Input Sheet:U12-@INT(Input
Sheet:U12))*100)-@INT(((Input Sheet:U12-@INT(Input
Sheet:U12))*100)))/0.6))/60)+(30*(@IF(Input Sheet:V12=1,12,Input
Sheet:V12-1)))) (In case you are wondering, it is part of a macro to
determine the new position of a star and in those days we had to
convert time input by the user into individual hours minutes and
seconds so they can be added and subtracted in a 24 hour clock.)
Anyway, thanks for your help
--
Starchaser
------------------------------------------------------------------------
Starchaser's Profile: http://www.excelforum.com/member.php...o&userid=30649
View this thread: http://www.excelforum.com/showthread...hreadid=503077