Ignor Spaces

[stevekirk]

HI,

D1 HAS IN IT LOOSE SHELF 1262X459 AND E1 HAS 262X459

i have extracted the 262X459 BY USING =RIGHT(D1,8) SO I DID EXPECT TO SEE
1262X459
what has happened is there is a space ater the 459
this space could accur in 50 % of the cell if i put = right(d1,9) i will get on this example f in my result

any idea how to ignor the space

thanks steve

[Bryan Hessey]

HI,

D1 HAS IN IT LOOSE SHELF 1262X459 AND E1 HAS 262X459

i have extracted the 262X459 BY USING =RIGHT(D1,8) SO I DID EXPECT TO SEE
1262X459
what has happened is there is a space ater the 459
this space could accur in 50 % of the cell if i put = right(d1,9) i will get on this example f in my result

any idea how to ignor the space

thanks steve

try =Len(D1) and =Right(D1,1) to check for spaces.

then =Trim(Right(D1,9) should work

---

[stevekirk]

hi bryan

i have tried to enter the first formular but it just gives me the error message

steve

[Dav]

=Trim(Right(D1,9) should work as suggested in the previous post

or

=right(trim(d1),8)

Regards

Dav

[oldchippy]

HI,

D1 HAS IN IT LOOSE SHELF 1262X459 AND E1 HAS 262X459

i have extracted the 262X459 BY USING =RIGHT(D1,8) SO I DID EXPECT TO SEE
1262X459
what has happened is there is a space ater the 459
this space could accur in 50 % of the cell if i put = right(d1,9) i will get on this example f in my result

any idea how to ignor the space

thanks steve

Hi stevekirk,

Try this formula,

=RIGHT(TRIM(D1),8)

oldchippy

[stevekirk]

thank you all

steve