Continuing the previous string functions posting Taking Characters in A Word to the Code, now we move on next string function, namely Make Taking Code with letters or numbers in a Word or Text with Excel.
For example we replace the function of MID, then the syntax would be as follows:
= VALUE(MID (source cell address; the initial character to be taken; the number of characters that will be taken))
An example is you type MH30RATEMU in cell A1 and you enter the formula =VALUE (MID (A1; 3; 2)) in cell C1 will display a 30 average of 30.
Note if the right in cell C1, meaning it into numeric data.
=TEXT(cell source address; text format)
To make the figure is still intact, enter text format with a zero (0).
For example, you write 1247 in the cell A1, then enter the formula =TEXT (A1; 0) then it will appear in 1247.
Note: if the data had been left flat in 1247, it was already a text data.
The syntax is =UPPER (cell address).
For example, you write charlie in cell A1, you enter the function =UPPER (A1) in cell C1, it appears CHARLIE.
Syntax =PROPER (cell address).
Example =PROPER (A1), before you enter the word charlie in cell A1, then the result is Charlie.
the syntax is =CONCATENATE (Address1; Address2; address 3; ...)
Examples you write CHARLIE on the A1, REALLY B1 and AWESOME on the C1, and enter =CONCATENATE (A1; B1; C1) then the result is CHARLIEREALLYAWESOME.
- Function Value
For example we replace the function of MID, then the syntax would be as follows:
= VALUE(MID (source cell address; the initial character to be taken; the number of characters that will be taken))
An example is you type MH30RATEMU in cell A1 and you enter the formula =VALUE (MID (A1; 3; 2)) in cell C1 will display a 30 average of 30.
Note if the right in cell C1, meaning it into numeric data.
- Text function
=TEXT(cell source address; text format)
To make the figure is still intact, enter text format with a zero (0).
For example, you write 1247 in the cell A1, then enter the formula =TEXT (A1; 0) then it will appear in 1247.
Note: if the data had been left flat in 1247, it was already a text data.
- Upper function
The syntax is =UPPER (cell address).
For example, you write charlie in cell A1, you enter the function =UPPER (A1) in cell C1, it appears CHARLIE.
- Proper function
Syntax =PROPER (cell address).
Example =PROPER (A1), before you enter the word charlie in cell A1, then the result is Charlie.
- Concatenate function
the syntax is =CONCATENATE (Address1; Address2; address 3; ...)
Examples you write CHARLIE on the A1, REALLY B1 and AWESOME on the C1, and enter =CONCATENATE (A1; B1; C1) then the result is CHARLIEREALLYAWESOME.
0 komentar:
Posting Komentar