Home 
Search 
Today's Posts 
#1




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




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




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




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




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




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




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




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




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




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) 