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

's Computer Specifications

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?

's Computer Specifications

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" <(E-Mail Removed)> wrote in message
news:3EAAD6E9-C337-4BF6-B721-(E-Mail Removed)...
> 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?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how do I convert text string into a cell reference	=?Utf-8?B?RGF2ZSBEYXZpcw==?=	Microsoft Excel Misc	3	10th Jun 2008 09:38 PM
Link or Cell Reference Within Text String	pogster@gmail.com	Microsoft Excel Worksheet Functions	5	28th Nov 2007 04:52 PM
Making cell reference absolute makes cell format text		Microsoft Excel Worksheet Functions	2	22nd Sep 2006 04:47 PM
convert text string to cell reference	=?Utf-8?B?QW5kcmV3?=	Microsoft Excel Misc	1	15th Dec 2003 06:44 PM
Re: Convert a Cell Reference to Text	Vasant Nanavati	Microsoft Excel Worksheet Functions	3	22nd Sep 2003 04:42 PM