Convert text string in format of cell reference to a cell reference

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way of converting a text string in the format of a valid cell reference i.e. " 'Sheet1'!F23 " to an actaul cell reference that could be used in a formula?
 
Frank

You could use the INDIRECT() function. This will use the value in the cell
as a cell reference. So if Merges!A1 was in B2, INDIRECT(B2) would return
the value in Merges!A1

Andy.

Frank said:
Is there any way of converting a text string in the format of a valid cell
Click to expand...
reference i.e. " 'Sheet1'!F23 " to an actaul cell reference that could be
used in a formula?
 
Back
Top