3 Digits

[Charlie]

Hi,
I have a formula when used displays B01/SW001
in a given cell, what I was wondering was how do I edit this formula to display only the last 3 digits of the second number, i.e B01/001, I am using this formula
=H8&"/"&A8.
Thanks
Charlie

 

[Aladin Akyurek]

On 2002-03-21 09:59, Charlie wrote:
Hi,
I have a formula when used displays B01/SW001
in a given cell, what I was wondering was how do I edit this formula to display only the last 3 digits of the second number, i.e B01/001, I am using this formula
=H8&"/"&A8.
Thanks
Charlie

=H8&"/"&RIGHT(A8,3)

 

[Charlie]

Thanks again,

Your help is much appreciated,this formula was one of those little ones that irritates.
Charlie

 

[kinkyparamour]

Try h8&"/"&right(a8,3)
This message was edited by kinkyparamour on 2002-03-21 10:16