=RIGHT(AZ4,LEN(AZ4)-FIND(CHAR(32),AZ4,1))
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"PeterM"
wrote in message
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.