Do we have a replace function?
I want to change a value.
Can you elaborate more ?0
I wanted to know, as we have 'Replace' in excel.
Do we have the similar in Anaplan?0
For text , SUBSTITUTE function is there which enables to replaces a portion in a text line item with a new string,
to replace numbers, you can convert into text using TEXT(), then substitute , then convert substitiuted text into number using value()
Whenever trying to convert from excel to Anaplan this is a helpful link:
Depending on your exact case, you could use a combo of FIND(), LEN(), LEFT(), RIGHT(), etc. Alternatively if you are finding a specific text and want change it for something else then you could use SUBSTITUTE() like @Kanishq17 mentioned above.