Fraud Blocker
Announcement bar drops down here to inform users of the latest news and sales!

Business microlearning from Japan’s No1 MBA

Edge

Excel Functions & Formulas: Text

31 minutes (1 section)

Course Description

Excel’s text functions allow you to handle text effectively.
They facilitate data cleaning, extraction, concatenation and manipulation.

This course covers how to:
• Edit text strings without changing text manually,
• Construct a function to count words in text strings,
• Separate the content of a single column into multiple separate columns,
• Find the position of a substring in both case-sensitive and case-insensitive search,
• Change the text case and remove unnecessary spaces from a text,
• Compare text in two different cells and replace text in a cell,
• Join text and a number in the same cell,
• And, join several text strings and extract the required substring from a string.

Join us, and explore how you handle text in spreadsheets and enhance productivity!

Share this course:

Related Courses

Relieve upper and lower back tension fast with easy exercises you can do right at your desk.
1 videos
2 min
Learn how to recognize, understand, and support mental health in the workplace to create a more inclusive, resilient culture.
4 videos
8 min
Explore how oligarchies form, shape business and politics, and why concentrated power impacts competition and fairness.
1 videos
4 min
Discover what ikigai means, why it matters, and how it can help you find purpose, fulfillment, and direction in both your work and everyday life.
4 videos
8 min
Quick desk exercises to release neck and shoulder tension, improve posture, and boost comfort during your workday.
1 videos
2 min

Start your free trial

Sign up to watch the rest of this course for free - no strings attached!
Continue with a subscription of USD 16.67 / month* after free trial ends
*USD 99.99 billed every 6 months