manipulating text strings that are cell references

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 
Back
Top