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?
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?