View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cardan cardan is offline
external usenet poster
 
Posts: 112
Default Extracting a Part of a Formula as Text

Hello, I have what I think may be an easy question. I am trying to extract part of the formula into a new cell.

In Cell A1 in Sheet2, the formula is =Sheet1!B2. In Cell A2,Sheet2, I need a formula that will return the last 2 characters in the formula "B2".

Is this possible without VBA? Any help would be greatly appreciated. Thank You.