Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Is there a way in Excel 2003 to build the following formula WITHOUT using "'s
(double quotes)? =RIGHT("12345 description for code 12345",LEN("12345 description for code 12345")-FIND(chr(32),"12345 description for code 12345",1)) I've tried replacing the double quotes with chr(34)& like the example below, but Excel doesn't like it... =RIGHT(chr(34)& 12345 description for code 12345 &chr(34),LEN(chr(34)& 12345 description for code 12345 &chr(34))-FIND(chr(32),chr(34)& 12345 description for code 12345 &chr(34),1)) thanks in advance for your help |