|
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. |
Double Quotes
=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. |
Double Quotes
Thanks for responding...
Your solution works for a space, but I still need to resolve the double quote issue. For Example =RIGHT("12345 description for code 12345",LEN("12345 description for code 12345")-FIND(chr(32),"12345 description for code 12345",1)) In order to remove the double quotes, I've rewritten it replacing all double quotes with chr(34) adding the & for concatatnation...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)) and excel doesn't like it...any ideas? "Jim Cone" wrote: =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. |
Double Quotes
Chr is used with VBA.
Char is used in a spreadsheet. Jim Cone "PeterM" wrote in message Thanks for responding... Your solution works for a space, but I still need to resolve the double quote issue. For Example =RIGHT("12345 description for code 12345",LEN("12345 description for code 12345")-FIND(chr(32),"12345 description for code 12345",1)) In order to remove the double quotes, I've rewritten it replacing all double quotes with chr(34) adding the & for concatatnation...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)) and excel doesn't like it...any ideas? "Jim Cone" wrote: =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. |
Double Quotes
I understand that...how would you rewrite the following...
=RIGHT("12345 description for code 12345",LEN("12345 description for code 12345")-FIND(chr(32),"12345 description for code 12345",1)) thanks! "Jim Cone" wrote: Chr is used with VBA. Char is used in a spreadsheet. Jim Cone "PeterM" wrote in message Thanks for responding... Your solution works for a space, but I still need to resolve the double quote issue. For Example =RIGHT("12345 description for code 12345",LEN("12345 description for code 12345")-FIND(chr(32),"12345 description for code 12345",1)) In order to remove the double quotes, I've rewritten it replacing all double quotes with chr(34) adding the & for concatatnation...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)) and excel doesn't like it...any ideas? "Jim Cone" wrote: =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. |
" issue
char(34) works fine for me on excel 2007.
|
| All times are GMT +1. The time now is 12:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com