Hello I Am Balram Singh Welcome To Our TH-cam Channel.
Aio Digital Institute Provides Computer Education To The Students Through Live And Tutorials Videos.
LEFT: Extracts a specified number of characters from the start of a text string.
Syntax: =LEFT(text, [num_chars])
RIGHT: Extracts a specified number of characters from the end of a text string.
Syntax: =RIGHT(text, [num_chars])
MID: Extracts a specified number of characters from the middle of a text string.
Syntax: =MID(text, start_num, num_chars)
LEN: Returns the length of a text string.
Syntax: =LEN(text)
FIND: Finds the starting position of one text string within another text string (case-sensitive).
Syntax: =FIND(find_text, within_text, [start_num])
SUBSTITUTE: Replaces occurrences of a specified text string with another text string.
Syntax: =SUBSTITUTE(text, old_text, new_text, [instance_num])
CONCATENATE (or CONCAT in newer versions): Joins two or more text strings into one string.
Syntax: =CONCATENATE(text1, [text2], ...)
UPPER: Converts all characters in a text string to uppercase.
Syntax: =UPPER(text)
LOWER: Converts all characters in a text string to lowercase.
Syntax: =LOWER(text)
TRIM: Removes extra spaces from a text string, leaving only single spaces between words.
Syntax: =TRIM(text)
These functions are incredibly useful for cleaning up and organizing text data in Excel.
Download Practice File Link
docs.google.com/spreadsheets/d/1qjw6ZEhjRXD1x1torftHl8UUsMeZt_80/edit?usp=sharing&ouid=104869837764050704946&rtpof=true&sd=true
excel
excel formulas
excel formula
microsoft excel
excel tutorial
ms excel
excel formula for job interview
excel tips and tricks
excel formulas and functions
excel tutoring
excel formulas and functions tutorial
excel tips
excel formula hacks
excel shorts
excel interview questions
excel 2016
excel functions
percentage formula in excel
excel 2019
ms excel tutorial
excel if formula
advanced excel
excel interview
sum formula in excel
learn excel
text function in excel
text functions
text functions in excel
excel functions
excel
text function
microsoft excel
text function in excel 2016
excel text function
text formula in excel
text functions in excel with examples
functions
excel 2013
text functions in power query
excel if function
excel formulas
excel tutorial
ms excel
all text functions in excel
text functions in excel 2016
text functions in excel 2019
text functions in ms excel
#msexcel #balramexcel #excelformulas #exceltutorial #exceltips
Contact
Email - aiodigitalinstitute@gmail.com