3 Digits

Charlie · Mar 21st, 2002, 10:59 AM

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 · Mar 21st, 2002, 11:10 AM

Quote:

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 · Mar 21st, 2002, 11:14 AM

Thanks again,

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

kinkyparamour · Mar 21st, 2002, 11:15 AM

Try h8&"/"&right(a8,3)

[ This Message was edited by: kinkyparamour on 2002-03-21 10:16 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 21st, 2002, 10:59 AM	#1
Charlie Board Regular Join Date: Mar 2002 Posts: 134	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

Mar 21st, 2002, 11:14 AM	#3
Charlie Board Regular Join Date: Mar 2002 Posts: 134	Thanks again, Your help is much appreciated,this formula was one of those little ones that irritates. Charlie

Mar 21st, 2002, 11:15 AM	#4
kinkyparamour Board Regular Join Date: Feb 2002 Location: Florida Posts: 82	Try h8&"/"&right(a8,3) [ This Message was edited by: kinkyparamour on 2002-03-21 10:16 ]