Remove prefix from formula result

[Lisa McConachy]

I have the following formula that I want to return only the numbers after the /. Can I add to the formula to remove the prefix also? Very New to excel!!

=IF('Field Data Entry'!$AE$17<'Field Data Entry'!$C$19,"",IF('MDD 1_Data Entry'!$F$6="","",'MDD 1_Data Entry'!$F$6))

MDD 1_Data Entry'!$F$6 = AAA20/100

 

[DanteAmor]

Try this

=IF('Field Data Entry'!$AE$17<'Field Data Entry'!$C$19,"",IF('MDD 1_Data Entry'!$F$6="","",TRIM(MID('MDD 1_Data Entry'!$F$6,FIND("/",'MDD 1_Data Entry'!$F$6)+1,255))))

 

[Lisa McConachy]

Worked a treat, Thank you!!!

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.