Importing Excel into JMP - Concat Excel Not Transferring Over
Hi there - I'm using the Import function on JMP to import an excel into JMP (because I will be updating the excel file and want the JMP file to update).I have a few =concat() functions in the excel file, and whenever I import into JMP via wizard, in JMP it shows up as #NAME? for every cell that has the concat function, rather than displaying the actual value as it does in excel.What is the workaro...