substitute function in calculated column

_{Tuesday, March 27, 2012 6:42 AM}

Hello All,

why Substitute function is not working in SharePoint list calculated column?

I tested with Replace and Search/Find functions, but they are not helpful and looking hectic.

Thanks

Like Cricket

_{Tuesday, March 27, 2012 7:26 AM ✅Answered}

Not all Excel function are available to use in SharePoint formulas.

Here is a list of possible functions.

Also, look at this example of alternating Substitute function. May be it will be suitable for you.

Don't happy, be worry...

_{Tuesday, March 27, 2012 7:37 AM | 1 vote}

Hi,

You can find help from here:

and

Wali Systems Inc. (http://walisystemsinc.com) Hire certified virtual SharePoint assistants/developers!

_{Tuesday, March 27, 2012 11:59 AM}

check this and let me know if it helped you

Additional resources