software

Cell A1 of the Input Sheet, for example might contain the words quot;Daily
Sale Report 5quot;
Cell A5 of the Output Sheet contains the formula: ='Input Sheet'!$A$1
thus displaying whatever the contents of cell A1 from the Input Sheet.
I want another cell on the Output Sheet to contain the editable results
of the formula ... e.g. quot;Daily Sale Report 5quot; ... (NOT the equation).
Is there a way to do this?


Hello ZBC2,

For example using cell A6 for the result, the formula would be...

=TEXT(A5, Len(A5))

Sincerely,
Leith Ross--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: www.excelforum.com/member.php...oamp;userid=18465
View this thread: www.excelforum.com/showthread...hreadid=506103Leith Ross wrote:

gt;Hello ZBC2,
gt;
gt;For example using cell A6 for the result, the formula would be...
gt;
gt;=TEXT(A5, Len(A5))
gt;
gt;Sincerely,
gt;Leith Ross
gt;
gt;
gt;
gt;
THANK YOU!

Leith Ross wrote:

gt;Hello ZBC2,
gt;
gt;For example using cell A6 for the result, the formula would be...
gt;
gt;=TEXT(A5, Len(A5))
gt;
gt;Sincerely,
gt;Leith Ross
gt;
gt;
gt;
gt;
I just realized that it still shows up as an equation in cell A6 ...
I guess I want to permanently replace A6 with it's contents ??? and not
show up as an equation ???


Hello ZBC2,

Change the formula in A6 (Output Sheet) to this...

=TEXT(Sheet1!$A$1, Len(Sheet1!$A$1))

If this doesn't work for you, then I have no idea what the problem is.

Sincerely,
Leith Ross--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: www.excelforum.com/member.php...oamp;userid=18465
View this thread: www.excelforum.com/showthread...hreadid=506103Leith Ross wrote:

gt;Hello ZBC2,
gt;
gt;Change the formula in A6 (Output Sheet) to this...
gt;
gt;=TEXT(Sheet1!$A$1, Len(Sheet1!$A$1))
gt;
gt;If this doesn't work for you, then I have no idea what the problem is.
gt;
gt;Sincerely,
gt;Leith Ross
gt;
gt;
gt;
gt;
The first expression you gave me displays the cell contents ok; the
problem is that it is still a 'formula'.
I want to convert the formula to the 'results' of the formula.

Bob

Edit / Copy, then Edit / Paste Special / Values

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------
quot;ZBC2quot; gt; wrote in message
...
gt; Leith Ross wrote:
gt;
gt;gt;Hello ZBC2,
gt;gt;
gt;gt;Change the formula in A6 (Output Sheet) to this...
gt;gt;
gt;gt;=TEXT(Sheet1!$A$1, Len(Sheet1!$A$1))
gt;gt;
gt;gt;If this doesn't work for you, then I have no idea what the problem is.
gt;gt;
gt;gt;Sincerely,
gt;gt;Leith Ross
gt;gt;
gt;gt;
gt;gt;
gt; The first expression you gave me displays the cell contents ok; the
gt; problem is that it is still a 'formula'.
gt; I want to convert the formula to the 'results' of the formula.
gt;
gt; Bob
Ken Wright wrote:

gt;Edit / Copy, then Edit / Paste Special / Values
gt;
gt;
gt;
I was hoping to not do it manually ...

You can do it via code, but thats it. There is no function/formula that
will convert itself to text automatically.

Regards
Ken.......................

quot;ZZBCquot; gt; wrote in message
...
gt; Ken Wright wrote:
gt;
gt;gt;Edit / Copy, then Edit / Paste Special / Values
gt;gt;
gt;gt;
gt; I was hoping to not do it manually ...
Ken Wright wrote:

gt;You can do it via code, but thats it. There is no function/formula that
gt;will convert itself to text automatically.
gt;
gt;Regards
gt; Ken.......................
gt;
gt;quot;ZZBCquot; gt; wrote in message
...
gt;
gt;
gt;gt;Ken Wright wrote:
gt;gt;
gt;gt;
gt;gt;
gt;gt;gt;Edit / Copy, then Edit / Paste Special / Values
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;gt;I was hoping to not do it manually ...
gt;gt;
gt;gt;
gt;
gt;
gt;
gt;
Darn! I'm not sure I want to go that route ... Thanks!