do not find same result

[majidsiddique]

hi,
i have problem in Cell Value:
value of A1 cell:
[TABLE="width: 348"]
<tbody>[TR]
[TD="width: 348"]MD-5001219 - onyx - surgeryitem - 00016220228000
i use formula:
=LEFT(A1,FIND(" ",A1)-1)
result ok if change the cell value
but in
=RIGHT(A1,FIND(" ",A1)-1)
result would changed when i change the value of cell, why?
can anybody tell me.[/TD]
[/TR]
[TR]
[TD="width: 348"][/TD]
[/TR]
</tbody>[/TABLE]

 

[majidsiddique]

really excellent work steve boss,
you are so smart.
thanks a lot.