Eliminating Single Quote Before Equals Sign

S

Steveinneed

I am using CONCATENATE to make equations and functions in Excel 2000. When I
concatenate ='C:\... to other text and then save as a value I get '='C:\...,
which is treated as text instead of as an equation. Trying to change '= to =
doesn't work because the leading ' isn't recognized. Any suggestions?
Thanks
Steve
 
I

Ian Huitson

try using the Indirect Function instead

+indirect(Concatenate(text1, text2,text3...))

The text1 etc will need quotes " " around it if you want to use an = sign

Regards

Ian Huitson
 

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

How do I install Microsoft Equation 3.0 back to Office 365? 0
Array formula works on first row only 5
Foot mark aka single quote mark? 3
Concatenate a Formula 4
Problem with Concatenate - Results are too long for CSV 4
Double Equals Operator? 5
Excel solver should allow "equal to" value to be a selected cell. 1
compare cells, copy, loop 2

Top