Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I convert a formula to it's results?
Cell A1 of the Input Sheet, for example might contain the words "Daily
Sale Report 5" 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. "Daily Sale Report 5" ... (NOT the equation). Is there a way to do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I convert a formula to it's results?
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: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=506103 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I convert a formula to it's results?
Leith Ross wrote:
Hello ZBC2, For example using cell A6 for the result, the formula would be... =TEXT(A5, Len(A5)) Sincerely, Leith Ross THANK YOU! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I convert a formula to it's results?
Leith Ross wrote:
Hello ZBC2, For example using cell A6 for the result, the formula would be... =TEXT(A5, Len(A5)) Sincerely, Leith Ross 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 ??? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I convert a formula to it's results?
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: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=506103 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I convert a formula to it's results?
Leith Ross wrote:
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 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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I convert a formula to it's results?
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 :-) ------------------------------*------------------------------*---------------- "ZBC2" wrote in message ... Leith Ross wrote: 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 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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I convert a formula to it's results?
Ken Wright wrote:
Edit / Copy, then Edit / Paste Special / Values I was hoping to not do it manually ... |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I convert a formula to it's results?
You can do it via code, but thats it. There is no function/formula that
will convert itself to text automatically. Regards Ken....................... "ZZBC" wrote in message ... Ken Wright wrote: Edit / Copy, then Edit / Paste Special / Values I was hoping to not do it manually ... |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I convert a formula to it's results?
Ken Wright wrote:
You can do it via code, but thats it. There is no function/formula that will convert itself to text automatically. Regards Ken....................... "ZZBC" wrote in message ... Ken Wright wrote: Edit / Copy, then Edit / Paste Special / Values I was hoping to not do it manually ... Darn! I'm not sure I want to go that route ... Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trending Formula Results by Date | Excel Worksheet Functions | |||
Convert text to formula - Help pleaaase | Excel Discussion (Misc queries) | |||
View formula results instead of formula in 2003 version? | Excel Discussion (Misc queries) | |||
How do I prevent incorrect formula results appearing in cell? | Excel Worksheet Functions | |||
I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) |