Remove last 5 digits of a number? (I have a partially working formula)

[Marq]

Using 365

I have a column that will have either a 15 digit number or "<NONE>" without the quotes.

I want to have a column next to it with a formula basically saying:

If the cell has 15 digits, then remove only the last 5 digits.....and if it has <NONE> in the cell then populate it with WORK

for example in column AG cells I will have something like this:

123456789101112
<NONE>

in column AH I want it to show up as:

1234567891
WORKED

I am using this to remove the last 5 digits : =LEFT(AG3,LEN(AG3)-5)

I cant figure out how to get the WORKED to show up for the <NONE>

 

[Peter_SSs]

Like this?

Book1
	AG	AH
1	123456789101112	1234567891
2	<NONE>	WORKED
Sheet1

Cell Formulas
Range	Formula
AH1:AH2	AH1	=IF(AG1="<NONE>","WORKED",LEFT(AG1,LEN(AG1)-5))

 

[Fluff]

How about

=if(len(AG3)=15,left(AG3,10),"WORK")

 

[Marq]

Like this?

Book1
	AG	AH
1	123456789101112	1234567891
2	<NONE>	WORKED
Sheet1

Cell Formulas
Range	Formula
AH1:AH2	AH1	=IF(AG1="<NONE>","WORKED",LEFT(AG1,LEN(AG1)-5))

that works..thanks!

 

[Marq]

How about

=if(len(AG3)=15,left(AG3,10),"WORK")

yours worked too! Thanks

 

[Fluff]

Glad we could help & thanks for the feedback.