Excel Formula Write

Help Studio
, ,
1

Hey guys,

I’m trying to write below code in Write cell but when I try it gives error , anyone can help me about it ?

My formula trying to write : “=RIGHT(A2;LEN(A2)-FIND(”=“;A2))”

It gives error :

Write Cell: The write operation failed, because one of the following reasons:
► The data you want to write “=SAĞDAN(A2;UZUNLUK(A2)-BUL(”=“;A2))” has a wrong format;
► Excel is busy;
► If your data is a formula, make sure you use comma as parameters separator;
► During the write operation make sure no dialog windows are opened.

Thanks

1 Like
2

Hi @burakavuncu ,
You can watch this video. It could help you.

1 Like
3

Any other solution ?

1 Like
4

It works when you replace the semicolon you used in the formula with a comma. Also, you should use two double quotes in formulas where you use double quotes.

"=RIGHT(A2,LEN(A2)-FIND(""="",A2))"

image
image496×565 11.5 KB

1 Like
5

I think its about Turkish Language excel, cause when I try in turkish language not working.

1 Like
6

Burak,
Evet, Türkçe kullandığın Excel’de sıkıntı yaşaman çok normal. Eğer kurumsal bir proje yapıyor isen, Excel’in dilini ingilizceye çevirmen daha sağlıklı olacaktır. Bende de şuan Türkçe excel yok o yüzden deneyemiyorum. Excel’i Türkçe olarak değiştiremiyorum diyorsan ona göre bir çözüm arayalım. :slight_smile:
Not: Forum’da bizden birilerini görmek güzel :slight_smile:

1 Like
7

Selam,

Excel’i ingilizce yaparak sorunu çözdüm, çok teşekkür ederim :slight_smile:

1 Like
8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.