Jai’s Sharepoint blog

Interesting to note that most of the common formulae which works in Excel works in the calculated columns also.

For substrings, you could use functions like LEFT, RIGHT, MID and LEN