Double Quotes

[PeterM]

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.

 

[Jim Cone]

=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" <[email protected]>
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.

 

[PeterM]

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]

Chr is used with VBA.
Char is used in a spreadsheet.
Jim Cone


"PeterM"
<[email protected]>
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?

 

[PeterM]

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!

 

[AggieMOSS]

char(34) works fine for me on excel 2007.