Excel Help how would you

E

elway7

I typed this formula
formula is =ILX|Q!'AGR'B,Last (AGR'B is a stock symbol) if I type in 'AGR'B'
than it thinks that AGR is the end of the string, is there a way to have
excel take 'AGR'B' as a valid string?
 
Top