| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
" issue
char(34) works fine for me on excel 2007.
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| display double quotes in an cell | Excel Discussion (Misc queries) | |||
| Save As CSV, double quotes | Excel Discussion (Misc queries) | |||
| Double quotes when concatenating with CHAR(10) | Excel Discussion (Misc queries) | |||
| export .CSV with field containing double quotes? | Excel Discussion (Misc queries) | |||
| Escape character for double quotes | Excel Worksheet Functions | |||
Hybrid Mode
