SUBSTITUTE formula problem

Question

I am having a problem with SUBSTITUTE formula in Excel 64bit. Formula is created to replace Lat to Cyr characters and is working in Excel 32bit, but when I try to paste formula in Excel 64bit, there is an error message like "too many nestings".

The document created in Excel 32bit with the formula can be used in Excel 64bit, but it is not possible to create document with the formula in 64bit Excel.

Answer 1

Request you to please prepare and upload a sample / dummy file sans confidential / sensitive data to Onedrive and share the link here.

HOW TO UPLOAD

1. Login to https://onedrive.live.com/ utilizing the same Login ID and Password which you have used on this forum. (or use the installed Onedrive on your computer)
2. Click Upload in the top OR drag and drop the file here.
3. After uploading, right click the file and choose share.
4. Optional but recommended - Uncheck the Allow Editing
5. Click Get a Link.
6. Copy the link and paste the link here.

Do let me know if you require any further help on this. Will be glad to help you.

Answer 2

Yes, the error appears on a new document in Excel 64bit as well.

Answer 3

Have you saved your file as .xlsx? If not, save it as .xlsx, close it and open again.

Answer 4

Hi Vijay

here it is

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B2;"A";"A");"B";"Б");"V";"В");"G";"Г");"D";"Д");"Đ";"Ђ");"E";"Е");"Ž";"Ж");"Z";"З");"I";"И");"J";"Ј");"K";"К");"L";"Л");"M";"М");"N";"Н");"O";"О");"P";"П");"R";"Р");"S";"С");"T";"Т");"Ć";"Ћ");"U";"У");"F";"Ф");"H";"Х");"C";"Ц");"Č";"Ч");"Š";"Ш")

Answer 5

Hi Mirko

Greetings! I am Vijay, an Independent Advisor. I am here to work with you on this problem.

Can you let me know your formula?