Excel Tricks: Text Functions in Excel
How to use Text Functions in Excel
Excel is mostly about the numerical data, but at times you can come across the data which has too much text and that is the time when Text Functions in Excel will help you to simplify the things easily.
Here are few text functions you should know
1.Left()
You can use the Left function when you want to extract the leftmost characters from a string. Syntax =left(text, num_char)
Similarly, you can also use the Right function to extract the rightmost characters from a string.
2. Len ()
Len function in Excel helps you to know the length of a string that is number of characters in a string. Syntax = LEN(text)
Note – Spaces are included while calculating length.
3. Mid ()
Mid function in Excel is used to extract the characters from the middle of a string. Syntax = MID(text, start_char, num_chars)
4. Find ()
Find function in Excel is used when you want to know the position of certain characters in a particular string. Syntax =FIND(find_text, within_text,[start_num])
5. Proper ()
Proper function in Excel capitalizes each word in the string that is, it converts the case into proper case. Syntax =PROPER(Text)
6. Rept ()
Rept function in Excel is used when you want a certain text to be repeated certain number of times. Syntax =REPT(Text, number_times)
7. Trim()
Trim function in Excel removes the unnecessary spaces from a particular string. Syntax =TRIM(Text )
8. Upper()
Upper function in Excel converts the text into Upper case from lower case. Syntax =UPPER(Text )
9. Substitute ()
Substitute function in Excel helps to replace existing text with a new text in a particular string. Syntax =SUBSTITUTE(text, old_text, new_text, instance number)
10. Concatenate ()
Concatenate function in Excel helps to join the text of two or more cells. Syntax =CONCATENATE(text1, text2….)
If you have any doubts or suggestions for us, then do let us know in the comments section below and we shall get back to you at the earliest.
Related links you will like:
MAKE YOUR CAREER IN
Need more Info?
Tags
- ABOUT FRM COURSE IN INDIA
- ACCA
- ACCA CERTIFICATION
- ACCA COURSE
- ACCA COURSE DETAILS
- ACCA COURSE DURATION
- ACCA COURSE ELIGIBILITY CRITERIA
- ACCA COURSE STRUCTURE AND FEES IN INDIA
- ACCA COURSE SYLLABUS
- ADMISSION TO CFA
- BAT COURSE
- BEST FINANCIAL MODELING COURSE
- BEST FINANCIAL MODELING COURSE IN INDIA
- BEST ONLINE CFA PREP COURSE
- BEST ONLINE FINANCIAL MODELING COURSE
- CFA CERTIFICATION
- CFA COURSE
- CFA COURSE DETAILS
- CFA COURSE DURATION
- CFA COURSE FEES
- CFA COURSE FEES IN INDIA
- CFA COURSE IN INDIA
- CFA COURSE SYLLABUS
- CFA COURSE TRAINING
- CFA FOUNDATION COURSE
- CMA COURSE
- CMA COURSE DETAILS
- CMA COURSE DETAILS IN INDIA
- CMA COURSE DURATION.
- CMA COURSE ELIGIBILTY
- CMA COURSE IN INDIA
- CMA COURSE SYLLABUS
- CPA ACCOUNTANT
- CPA COURSE
- CPA COURSE DETAILS
- CPA COURSE DURATION
- CPA COURSE IN INDIA
- FINANCIAL MODELING
- FINANCIAL MODELING AND VALUATION
- FINANCIAL MODELING COURSE
- FINANCIAL MODELING COURSE IN INDIA
- FINANCIAL RISK MANAGER
- FRM COURSE
- FRM COURSE CERTIFICATION
- FRM COURSE CURRICULUM
- FRM COURSE DETAILS
- FRM COURSE DURATION
- FRM COURSE ELIGIBILITY
- FRM COURSE FEES
- FRM COURSE IN INDIA
- PGP BAT COURSE FEES
- PGP BAT COURSE SALARY IN INDIA
- PGP-BAT COURSE
- PGP-BAT COURSE DETAILS
- PGP-BAT COURSE DURATION
- PGP-BAT COURSE ELIGIBILITY
- PGP-BAT COURSE IN INDIA
- PGP-BAT COURSE INSTITUTE IN INDIA
- PLACEMENTS TO CFA
- US CMA COURSE
- US CMA PREPARATION
- US CPA COURSE
- WHAT IS ACCA COURSE
- WHAT IS CMA COURSE
- WHAT IS FINANCIAL MODELING COURSE
Leave a Reply