ExcelBanter - Formula to return text

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula to return text (https://www.excelbanter.com/excel-discussion-misc-queries/264654-formula-return-text.html)

casinel1

Formula to return text

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.

Bob Phillips[_4_]

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.

All times are GMT +1. The time now is 05:30 PM.