Copying partial text/number?

[Guest]

Hello
I am wondering is there a formula to copy part of a text/number to another cell?
e.g Weight = 233
copy 233 to another cell

 

[NateO]

Yes, in this case, if your original text is in cell a1, use the following:

=RIGHT(a1,3)+0

The 0 converts the new string to a number.

Cheers, Nate
This message was edited by NateO on 2002-03-12 09:02