Adding Trim to Existing Formula

[meppwc]

The following formula provides the correct result
FORMULA: =IFERROR(XLOOKUP(O2,'JEN DUFFY PDS'!N:N,'JEN DUFFY PDS'!O:O),"")
RESULT: 713794-B-113
I want to add a trim to the existing formula to show only the first 6 numbers
DESIRED RESULT: 713794
Can someone assist me with this?

 

[Phuoc]

Try this

FORMULA: =IFERROR(Left(XLOOKUP(O2,'JEN DUFFY PDS'!N:N,'JEN DUFFY PDS'!O:O),6),"")

 

[meppwc]

Perfect, and thank you so much