manipulating text strings that are cell references

G

Guest

I have a formula in a cell that creates a text string that represents a cell reference using the address function (i.e. the text string could be 'Sheet1'!D50). This text string varies depending on various inputs. I then want to extract the row and column number from this text string for use in a further formula. Is there anyway of doing this

Any help would be greatly appreciated
 
J

Joseph Meehan

Sorry this is the MS Access (the database program) newsgroup. Try
an MS Excel newsgroup.


--
Joseph E. Meehan

26 + 6 = 1 It's Irish Math


Andrew said:
I have a formula in a cell that creates a text string that represents a
Click to expand...
cell reference using the address function (i.e. the text string could be
'Sheet1'!D50). This text string varies depending on various inputs. I then
want to extract the row and column number from this text string for use in a
further formula. Is there anyway of doing this.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

manipulating text strings that are cell references 4
Remove certain characters from a text string 6
Last Modified By in a cell by user 3
Referring to columns in the text of a cell 2
Is there a function that will evaluate a text string in a cell? 2
EXCEL: find string in vector & return cell reference 1
Excel VBA 1
how do I create a cell reference from ADDRESS function return? 3

Top