Excel Insert Formular Format

[Markus3003]

Hi all,

please check my Screenshot:

I have a simple Excel Application Scope: I would like to insert a simple “=right(K2;8)” - formular like in the screenshot:

But the result looks like that:

Can you help me?

Thank you and BR
Markus

[ppr (Peter Preuss)]

can you check the formula syntax using = vs. +

[Markus3003]

@ppr , I tried both already, same result…

thank you

[Angel_Llull (Angel95)]

try “=RIGHT(K2;8)”

[Markus3003]

@Angel_Llull, as mentioned I tried it with “+” and with “=” but it is not working

[Angel_Llull (Angel95)]

Please, try with “=RIGHT(K2,8)”

It works for me in this way. I wrote it in the wrong way in the last post…sorry…

But, is this for one cell? or few cells?

If you have few cells, write “=RIGHT(K:K,8)”

[ppr (Peter Preuss)]

@Markus3003

@Markus3003

but it is not working

we prefer always to get details when something is not working.

For the formula syntax we do use =
You can try it manually in Excel

Maybe you are looking for something different like a autofill K2,K3,K4…
So we would recommend to share more details with us. Thanks for support

[Markus3003]

It was working with the “,”.
Thank you!!

@Angel_Llull
@ppr