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