Hi Macropod
Many thanks for your help. I got luck with the 2nd option you have shared. It works as expected.

However with the If condition I am either getting a syntax error or there is no result. Note that I am first pressing CTRL+F9 and then inserting the formula in your suggestion that begins with IF up till the final quotation mark. I guess I am making some mistake because you have mentioned that all braces are field braces. Does it mean that all the other braces in between should also be inserted using above keyboard shortcut?

Oh yes, exactly what I thought about my mistake. The repeating braces when inserted using CTRL+F9, worked fine. So now I have both options available for me.

You have no idea how desperate I was to figure this out.

Thank you very much and have a nice day.

Kind regards
Syed