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?
 
You must log in or register to reply here.

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

Range of cells: Convert relative reference into absolute 5
Reference to cell with text is returning #VALUE 5
Blank Cell Reference, without if statement 4
=IF function, reference problem to "text strings" in Data Validati 2
Invalid cell reference 1
Dependent "If" formulas 2
Can a text box use a formula or cell reference 3
Convert Date string to date format 7

Back
Top