Download
slide1 n.
Skip this Video
Loading SlideShow in 5 Seconds..
LEFT PowerPoint Presentation

LEFT

93 Vues Download Presentation
Télécharger la présentation

LEFT

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. LEFT • LEFT returns the first character or characters in a text string, based on the number of characters you specify. • Syntax • LEFT(text,num_chars)

  2. LEN • LEN returns the number of characters in a text string. • Syntax • LEN(text)

  3. LOWER • Converts all uppercase letters in a text string to lowercase. • Syntax • LOWER(text) • Text     is the text you want to convert to lowercase. LOWER does not change characters in text that are not letters.

  4. UPPER • Converts text to uppercase. • Syntax • UPPER(text) • Text     is the text you want converted to uppercase. Text can be a reference or text string.

  5. REPT • Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string. • Syntax • REPT(text,number_times) • Text     is the text you want to repeat. • Number_times     is a positive number specifying the number of times to repeat text.

  6. RIGHT • RIGHT returns the last character or characters in a text string, based on the number of characters you specify. • Syntax • RIGHT(text,num_chars) • Text     is the text string containing the characters you want to extract. • Num_chars     specifies the number of characters you want RIGHT to extract.

  7. MID • MID returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify. • Syntax • MID(text,start_num,num_chars) • Text     is the text string containing the characters you want to extract. • Start_num     is the position of the first character you want to extract in text. The first character in text has start_num 1, and so on. • Num_chars     specifies the number of characters you want MID to return from text