LEFT Function
This function will return specified number of character from left side of the supplied Text.
Syntax: LEFT(text,[number_chars])
Example: =LEFT("Google",3)
Result: Goo
Example: =LEFT("Google")
Result: G
If number of characters not mentioned it will return first character only.
Assignments:
1. Find left 4 character from "Pacific Ocean"
This function will return specified number of character from left side of the supplied Text.
Syntax: LEFT(text,[number_chars])
Example: =LEFT("Google",3)
Result: Goo
Example: =LEFT("Google")
Result: G
If number of characters not mentioned it will return first character only.
Assignments:
1. Find left 4 character from "Pacific Ocean"
No comments:
Post a Comment