View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Khoshravan
 
Posts: n/a
Default Len function returns bigger number

Hi Ken
Thanks for your comment. I performed both TRIM and Clean but both functions
still bring 17 for the result of LEN function for LEV(KP51). Very strange
--
Rasoul Khoshravan Azar
Civil Engineer, Osaka, Japan


"Ken Johnson" wrote:

Hi Rasoul,

If there are extra spaces TRIM worksheet function will remove them.
If they are nonprintable characters then CLEAN worksheet function will
get rid of them.

Ken Johnson