View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips[_4_] Bob Phillips[_4_] is offline
external usenet poster
 
Posts: 834
Default Formula to return text

Maybe

=OFFSET(G7,88,0)

--

HTH

Bob

"casinel1" wrote in message
...
Need some help here. I am using excel 2007 and I am merging cells - I
cannot
figure out a formula to give me the text in 91 columns below the previous
text.

Ex. Cell G7 = Unbalanced
Cell G95 = NVAA

What formula can I use to get me the text out of cell G95 using cell G7.
Ex
G7+what= NVAA(G95). Thanks.