I am building a report using a NL("Sheets") function which returns data like "#NTB………".
This hashtag at the beginning of the string seems to be a problem. For these values, sheets are created with the initial sheet name + a counter "(2)", "(3)", etc..
Does anyone know if this can be solved without having to change the source-data? Already tried the =SUBSTITUTE()-function outside and inside the NL("Sheets") but this didn't work.
Thanks in advance!!!
NL("Sheets") problem with values including a hashtag