Excel Shortcuts

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.

Talk to our experts!

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.
hitesh patil

Interested in this topic?

Recent Posts

Will CMA Online Classes Help You Pass the CMA Exam

Hello, and welcome back to our new blog. Are you preparing to take on the…

2 months ago

Key Insights for CFP® professionals from the 2024 Financial Planning Conclave.

Hello, and welcome back to our new blog. As the financial world continues to evolve,…

2 months ago

What You’ll Learn in Financial Planning Education

CFP® Course Curriculum: What You’ll Learn in Financial Planning Education | EduPristine Welcome back learners…

3 months ago

Capital Investment Decision in CFA®

Capital Investment Decision in CFA® | EduPristine Welcome back, learners, to another insightful blog post…

3 months ago

Techniques Used by CFP Practitioners to Enhance Client Wealth.

Techniques Used by CFP® Practitioners to Enhance Client Wealth | EduPristine Welcome back, financial planning…

3 months ago

How to Become a CPA Without a Degree in Accounting.

Hello, and welcome back to our latest blog. Have you ever wondered if you could…

3 months ago