Make Code With Take Some Letters or Numbers In Text Microsoft Excel

Posted by

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.


  • Function Value 
This function is used to take a number of text data and converts it into numeric data. In syntax function this value is = VALUE (TEXT) the intent of this text can be changed with the function that I have discussed above.  
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
This text function is used to convert a numeric data into text data. The syntax is:

=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
If you write the text data in a cell with a lowercase character, then you can enter the upper function is to convert it into capital letters.
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
This function is useful for changing the initial text a word at the cell into capital letters.  
Syntax =PROPER (cell address).  
Example =PROPER (A1), before you enter the word charlie in cell A1, then the result is Charlie.
  • Concatenate function
This is a useful function to combine some text on the sell different addresses.
the syntax is =CONCATENATE (Address1; Address2; address 3; ...)
Examples you write CHARLIE on the A1, REALLY B1 and A
WESOME on the C1, and enter =CONCATENATE (A1; B1; C1) then the result is CHARLIEREALLYAWESOME.  


Blog, Updated at: 18.57

0 komentar:

Posting Komentar