Alex Campbell
asked on
How to use Indirect function when tab name has spaces?
I am new to the indirect function.
I just found out about it from another question I asked, but now I tried it with a tab name that included a space.
Can the Indirect function use a tab name with spaces?
I just found out about it from another question I asked, but now I tried it with a tab name that included a space.
Can the Indirect function use a tab name with spaces?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Use:
=INDIRECT("'"&A1&"'"&"!A1" )
=INDIRECT("'"&A1&"'"&"!A1"
Oops - sorry Barry, I didn't refesh before pressing Submit. Not that it matters as you've already provided the solution and got the points.
Patrick
Patrick
ASKER
Great response time and completely answered the question.