Len | Left | Right | Mid | Upper | Lower | Proper | Trim | Google Sheets
#googleforeducation #googleforedu #gegagra #techiekrish
Text Functions in Google Sheets:
LEN:
Returns the length (number of characters) of a text string.
Useful for counting characters in cells.
Example: =LEN("Hello") returns 5.
LEFT:
Extracts a specified number of characters from the beginning (left side) of a text string.
Example: =LEFT("Google Sheets", 6) returns "Google".
RIGHT:
Extracts a specified number of characters from the end (right side) of a text string.
Example: =RIGHT("Google Sheets", 6) returns "Sheets".
MID:
Extracts a segment of a text string, starting at a specified position and for a specified number of characters.
Example: =MID("Google Sheets", 8, 5) returns "Sheet".
UPPER:
Converts a text string to all uppercase letters.
Example: =UPPER("hello") returns "HELLO".
LOWER:
Converts a text string to all lowercase letters.
Example: =LOWER("HELLO") returns "hello".
PROPER:
Capitalizes the first letter of each word in a text string.
Example: =PROPER("hello world") returns "Hello World".
TRIM:
Removes leading and trailing spaces from a text string.
Example: =TRIM(" Hello ") returns "Hello".
Tags:
#GoogleSheets
#Spreadsheets
#TextFunctions
#StringManipulation
#DataCleaning
#DataAnalysis
#SpreadsheetFormulas
#LEN
#LEFT
#RIGHT
#MID
#UPPER
#LOWER
#PROPER
#TRIM