How to get rid of hidden apostrophe?

Hi,
This is my first question on this forum, I tried to find an answer to my problem but was so far unable to…
So, I have this formula :slight_smile: IFS(
[Type]=“Entrée”,
CONCATENATE (“1”,
YEAR(TODAY())-2000,
“-”,
LOOKUP([_THISROW].[Nom/couleur],“Codes_barres”,“Nom/couleur”,“Num_Fab”),
“-”,
LOOKUP([_THISROW].[Nom/couleur],“Codes_barres”,“Nom/couleur”,“Num_ref”),
“-”,
WEEKNUM(TODAY()),
“-”,
DAY(TODAY()),
“-”,
[Numéro]),
[Type]=“Fille”,
CONCATENATE (
[Num_rouleau_parent],
“-”,
“F”,
“-”,
[Numéro_fille])
)
For the occurence “Entrée”, I get a hidden apostrophe in the Google Sheets table.


The apostrophe is not present for the other occurence. This creates problems further down the line in my app.
How can I avoid the creation of this apostrophe or suppress it?
Thanks for you help
Gérard

PS: the Type of the column is Text

2 quick statements:
Is Nom/couleur a ref to Codes_barres? if it is you can simply use dereferencing to get your values which is faster.

A solution to try to get a quick fix would be surrounding the whole expression in SUBSTITUTE(“apostrophe”, “”)

I think this would be some sort of bug since you’re concatenating “1” onto the front.

1 Like

Thanks.
Actually, your last sentence provided me with a fix to this “bug”: I’ve tried co concatenate with “A” onto the front and it didn’t create the hidden apostrophe. So, it’s kind of stupid, but I will do this systematically, then remove the “A” and my problem will be solved :relaxed:
Thanks again !
Gérard

1 Like