Sunday, November 25, 2007

How to work with Substr (S,n,m ) function

How to work with Substr (S,n,m ) function

To work with Substr (S,n,m ) function

Step 1

To work with Substr (S,n,m) function, the first thing you need to do is to open the Insert menu and then click the Function command.

Step 2

Later, it will display the Insert Function dialog box and you have to choose the String in the Function Category. Choose the Substr in the Function Name list box and then click the Ok button.

Step 3

Extract a substring of S starting with the character in position n and having at most m characters. The arguments m and n must be integers.

No comments: