0

NL("Sheets") problem with values including a hashtag

Hi all,

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

Regards,
Gerard

8 comments

Please sign in to leave a comment.