Formulas and Functions
ਇਸ ਕੰਟਰੋਲ ਦੀ ਸੋਧ ਕਰਨ ਨਾਲ ਇਹ ਪੰਨਾ ਆਪਣੇ ਆਪ ਅੱਪਡੇਟ ਹੋ ਜਾਵੇਗਾ

LEFT

The LEFT function returns a string value consisting of the specified number of characters from the left end of a given string value.

LEFT(source-string, string-length)

source-string: Any value.

string-length: An optional number value specifying the desired length of the returned string. string-length must be greater than or equal to 1.

Notes

  • If string-length is greater than or equal to the length of source-string, the string returned is equal to source-string.

Examples

=LEFT("one two three", 2) returns "on".

=LEFT("abc") returns "a".

=LEFT(60, 1) returns "6".

See alsoMIDRIGHT
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
ਕੋਈ ਮਦਦ ਮਿਲੀ?
ਅੱਖਰ ਸੀਮਾ: 250
ਵੱਧ ਤੋਂ ਵੱਧ ਅੱਖਰ ਸੀਮਾ 250 ਹੈ
ਫ਼ੀਡਬੈਕ ਲਈ ਤੁਹਾਡਾ ਧੰਨਵਾਦ।
Morty Proxy This is a proxified and sanitized view of the page, visit original site.