LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default Formula to read formula in a cell

In cell 'A1' I have the formula:

=A2+A3

In B1, is there a way I can write a formula that will grab the first
cell of that formula in 'A1' (in this example the answer would be A2).

Thanks,
 
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
Formula to read just the first 2 to 3 characters in a cell. Clemson Gene Excel Discussion (Misc queries) 2 January 11th 07 12:22 AM
CAN YOU SET GRAPH TO READ, FORMULA IN A CELL AS A BLANK CELL AJ-foster Excel Discussion (Misc queries) 2 July 15th 06 08:34 AM
How do I make a formula read a result rather than a formula Chris Excel Discussion (Misc queries) 7 June 20th 06 10:56 PM
How would this formula read Frantic Excel-er Excel Discussion (Misc queries) 5 May 24th 05 05:55 PM
can formula to read sheetname from a cell? Todd Excel Worksheet Functions 2 December 8th 04 06:21 PM


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

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

About Us

"It's about Microsoft Excel"