Page 65 - Penta Book's ICT Catalogue

LEFT, RIGHT, MID

If you want to extract a part of a string (substring) 2
use the LEFT, RIGHT and MID functions.

To use the MID function:
> Click cell B10. 1
> On the Formulas tab, in the Function
Library group, click Text. 2
> In the list, click MID. 3 1 3
> In the Function Arguments window, in the
Text box type A10. 4 It’s the cell from which 4
you are going to extract characters. 5
> In the Start_num box, type 4. 5 It’s the

position of the first character you want to 6
extract. 7
> In the Num_chars box, type 9. 6 You are 7 7
Computing and ICT . Sample Pages DIGITAL TEENS 2 MODULE 5 > Click OK. 7
specifying how many characters you want to
extract.

Similarly, you can use LEFT and RIGHT
functions to extract text from the left or

8 right of a text respectively 1
5. Analyzing data / Functions
/ Functions / Functions SUBSTITUTE
5. Analyzing data / Functions
GRADE

If you want to replace part of a text in a cell,
use the SUBSTITUTE function.

To use the SUBSTITUTE function:
> Click cell A13. 2
> On the Formulas tab, in the Function

Library group, click Text. 1 3
> In the list, click SUBSTITUTE. 2 4
> In the Function Arguments window,
in the Text box, type A12. 3 It’s the cell 5
that contains the part of the text which
you are going to replace.

> In the Old_text, type spreadsheet. 4
This is the word you want to change.

> In the New_text, type worksheet. 5
This is the new word.

> Click OK. Your text has been replaced. 6
64 Penta Books 6