Len function returns bigger number

Hi Ken,

If your suggestions do not resolve Rasoul's problem, it is possible that his
data includes non breaking space characters.


---
Regards,
Norman



"Ken Johnson" <KenCJohnson@gmail.com> wrote in message
news:1148191276.610827.126630@i39g2000cwa.googlegroups.com...
> 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
>

Hi Norman
I am reading David TrimAll article hopefully to solve the issue.
New Findings:
PipeID (" KP51") has one space in the beginning
I did following two actoins. Result are interesting
Left(A1;5) and LEN for this returns: 17
MID(A1;2;4) and LEN for this returns: 17
So probably this is Char 160 which Norman mentions and according to David,
they will not be cleaned or Deleted by TRIM and CLEAN.
--
Rasoul Khoshravan Azar
Civil Engineer, Osaka, Japan


"Norman Jones" wrote:

> Hi Ken,
>
> If your suggestions do not resolve Rasoul's problem, it is possible that his
> data includes non breaking space characters.
>
>
> ---
> Regards,
> Norman
>
>
>
> "Ken Johnson" <KenCJohnson@gmail.com> wrote in message
> news:1148191276.610827.126630@i39g2000cwa.googlegroups.com...
> > 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
> >
>
>
>

Hi Norman,

Thanks for that. Something new for me to learn.

Ken Johnson