Remember Me?

#1
January 29th 06, 02:51 AM posted to microsoft.public.excel.misc
 ZBC2 Posts: n/a
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
January 29th 06, 03:12 AM posted to microsoft.public.excel.misc
 Leith Ross Posts: n/a
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

#3
January 29th 06, 06:37 AM posted to microsoft.public.excel.misc
 ZBC2 Posts: n/a
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
January 29th 06, 07:14 AM posted to microsoft.public.excel.misc
 ZBC2 Posts: n/a
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
January 29th 06, 07:29 AM posted to microsoft.public.excel.misc
 Leith Ross Posts: n/a
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

#6
January 29th 06, 11:40 AM posted to microsoft.public.excel.misc
 ZBC2 Posts: n/a
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
January 29th 06, 02:00 PM posted to microsoft.public.excel.misc
 Ken Wright Posts: n/a
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
January 29th 06, 02:10 PM posted to microsoft.public.excel.misc
 ZZBC Posts: n/a
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
January 29th 06, 02:13 PM posted to microsoft.public.excel.misc
 Ken Wright Posts: n/a
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
January 29th 06, 02:17 PM posted to microsoft.public.excel.misc
 ZZBC Posts: n/a
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!

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post sony654 Excel Worksheet Functions 0 January 2nd 06 02:33 AM Ayrton Excel Discussion (Misc queries) 5 December 7th 05 05:26 PM Felicia Pickett Excel Discussion (Misc queries) 2 September 14th 05 12:14 AM Marc Todd Excel Worksheet Functions 2 January 26th 05 07:57 AM ocbecky Excel Discussion (Misc queries) 4 December 10th 04 08:39 PM

All times are GMT +1. The time now is 02:46 PM.