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(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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |