Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 19
Default RIGHT

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 06:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"