Formula nested
Posted by Jack on December 18, 2001 11:22 AM
A1 = 100
in b1 = REM1 or 2 or 3 say
in D1 = ???? Im looking for something like this but D1 already has say REM1 sent 1 Dec 2001
OK i will paste a formula to make this happen but the ALT + Enter should force new line to make easier to read and Ermm im stuck there
d1 = new pasted formula + was already in D1, i paste in from and nest with & "text"
ok formula might be =B1 & "Sent " & Text(NOW(),"dd dddd mmm yyyy" & " " & "@ $" & A1 (Force new line & D1 origanal by & " end original "
Any way to include origal D1 at the end and how do i force new row in formula, can do manual but then copy Paste as value and F2 find point and Alt+Enter the enter
Any ideas, as you guess i do hundreds a day, and its driving me a little mad!
A big thats again for any help
Posted by Artemidorus on December 19, 2001 4:34 PM
You cannot include the original value of D1 in the formula (creates a circular ref). Could be done with VBA.
Why not enter the formula in E1 ?
To put the original D1 value on a second line, format E1 as Wrap Text and then enter this formula :-
=B1 & " Sent " & TEXT(NOW(),"dd dddd mmm yyyy") & " " & "@ $" & A1 & CHAR(10) & D1
Posted by Jack in UK CHAR(10) Perfection big thanks on December 21, 2001 11:21 AM
