Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 29th 06, 03:51 AM posted to microsoft.public.excel.misc
ZBC2
 
Posts: n/a
Default 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   Report Post  
Old January 29th 06, 04:12 AM posted to microsoft.public.excel.misc
Leith Ross
 
Posts: n/a
Default 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   Report Post  
Old January 29th 06, 07:37 AM posted to microsoft.public.excel.misc
ZBC2
 
Posts: n/a
Default 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   Report Post  
Old January 29th 06, 08:14 AM posted to microsoft.public.excel.misc
ZBC2
 
Posts: n/a
Default 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   Report Post  
Old January 29th 06, 08:29 AM posted to microsoft.public.excel.misc
Leith Ross
 
Posts: n/a
Default 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   Report Post  
Old January 29th 06, 12:40 PM posted to microsoft.public.excel.misc
ZBC2
 
Posts: n/a
Default 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   Report Post  
Old January 29th 06, 03:00 PM posted to microsoft.public.excel.misc
Ken Wright
 
Posts: n/a
Default 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   Report Post  
Old January 29th 06, 03:10 PM posted to microsoft.public.excel.misc
ZZBC
 
Posts: n/a
Default 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   Report Post  
Old January 29th 06, 03:13 PM posted to microsoft.public.excel.misc
Ken Wright
 
Posts: n/a
Default 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   Report Post  
Old January 29th 06, 03:17 PM posted to microsoft.public.excel.misc
ZZBC
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trending Formula Results by Date sony654 Excel Worksheet Functions 0 January 2nd 06 03:33 AM
Convert text to formula - Help pleaaase Ayrton Excel Discussion (Misc queries) 5 December 7th 05 06:26 PM
View formula results instead of formula in 2003 version? Felicia Pickett Excel Discussion (Misc queries) 2 September 14th 05 12:14 AM
How do I prevent incorrect formula results appearing in cell? Marc Todd Excel Worksheet Functions 2 January 26th 05 08:57 AM
I want the results of a formula to show in cell, NOT THE FORMULA! ocbecky Excel Discussion (Misc queries) 4 December 10th 04 09:39 PM


All times are GMT +1. The time now is 03:04 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017