Formulas and Functions
இந்தக் கட்டுப்பாட்டை மாற்றினால் இந்தப் பக்கம் தானாக மாற்றப்படும்

MID

The MID function returns a string value consisting of the given number of characters from a string value starting at the specified position.

MID(source-string, start-pos, string-length)

source-string: Any value.

start-pos: A number value specifying the position within the specified string at which the action should begin. start-pos must be greater than or equal to 1 and less than or equal to the number of characters in source-string.

string-length: A 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, beginning at start-pos.

Examples

=MID("lorem ipsum dolor sit amet", 7, 5) returns "ipsum".

=MID("1234567890", 4, 3) returns "456".

=MID("shorten", 5, 20) returns "ten".

See alsoLEFTRIGHT
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.