| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested formula to search a text string and return specific text | Excel Worksheet Functions | |||
| Formula to sum text and return number | Excel Discussion (Misc queries) | |||
| Return Text in an IF formula | Excel Discussion (Misc queries) | |||
| Return formula as text | Excel Worksheet Functions | |||
| Link to text and return text into a formula? | Excel Worksheet Functions | |||
Hybrid Mode
