Formula question

[#1]

Hi

I have som data called KundeNr

601

602

603

etc

901

902

903

etc

And here I need to add a letter in front of these

So S601, S602, S603 etc and F901, F902, F903 etc

So now I have KundeNr as Store and then I would like to make If(KundeNr < 800, "S" & KundeNr, "F" & KundeNr) as Store. But it do not work. Probably not the right formula. And that is what I need. So anybody help?

best regards

Bjarne

[#2 · Accepted solution]

Use single quotes instead of double quotes.