The problem I had with lambda's is getting them into a new workbook when I needed them. This VBA code will load them with a click/call. just need to convert quotes to double quotes.
Sub LoadLambda()
ActiveWorkbook.Names.add Name:="todec", RefersToR1C1:="=LAMBDA(imperial,[to_cFactor],LET(cf,IF(ISOMITTED(to_cFactor),1,to_cFactor),si,IF(LEFT(imperial,1)=""-"",-1,1),IF(ISBLANK(imperial),""n/a"",IF(ISNUMBER(imperial),imperial*cf,LET(ft,IFERROR(ABS(VALUE(LEFT(imperial,(FIND(""'"",imperial)-1)))),0),in,TRIM(SUBSTITUTE(SUBSTITUTE(IFERROR(RIGHT(imperial,LEN(imperial)-FIND(""'"",imperial)),imperial),""-"",""""),"""""""","""")),IFERROR(si*(ft*12+VALUE(IF(ISERR(AND(FIND("" "",in),FIND(""/"",in))),IFERROR(VALUE(""0 ""&in),in),in)))*cf,""n/a""))))))"
ActiveWorkbook.Names("todec").Comment = "Convert various imperial format feet-inches to decimal with optional argument convert to-factor [cFactor]"
End Sub