Thread: Double Quotes
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
PeterM PeterM is offline
external usenet poster
 
Posts: 19
Default Double Quotes

Is there a way in Excel 2003 to build the following formula WITHOUT using "'s
(double quotes)?

=RIGHT(AZ4,LEN(AZ4)-FIND(" ",AZ4,1))

ultimately I'm hoping to build a cell with the following formula...I know it
doesn't make sense, but trust me I need to create it...and I can't use double
quotes

=RIGHT("12345 description for code 12345",LEN("12345 description for code
12345")-FIND(" ","12345 description for code 12345",1))

I ultimately need the cell to contain the value

description for code 12345

How do you build the formula above without using " (double quotes)....I
tried using chr(34)& and Excel won't accept that...

Any help would be appreciated.