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: 553
Default Referring To Contents Of Formula

Any idea how to refer to/use the contents of a formula in one cell in another
formula? For example you can type a formula like:
=Left(A1,5)
Now, suppose if cell A1 contains a formula like =Sum(... ... ...)
How, to get the first five characters of the formula existing in A1, i.e.
"=SUM(" ?
--
Best Regards,
FARAZ A. QURESHI
 
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
Using the drag down function and formula referring to other worksh Keith Excel Discussion (Misc queries) 3 July 27th 07 01:44 AM
Referring to Sheet locations in a formula PCLIVE Excel Worksheet Functions 4 June 30th 07 11:28 PM
Formula referring to a dynamic range in a different workbook mr tom Excel Worksheet Functions 6 March 29th 07 08:56 AM
Formula referring to a different sheet luvthavodka Excel Discussion (Misc queries) 1 November 12th 06 10:05 PM
formula works when referring to one cell but not to another Nicci New Users to Excel 3 July 7th 06 02:03 PM


All times are GMT +1. The time now is 08:47 AM.

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"