Shiva Jayagopal is an Entrepreneur, a Freelancer – Software Testing Trainer, a Coach and a Consultant with over 22 years of IT experience. He is an Alumni of Microsoft, Adobe, Keane and Wipro with a strong passion for Quality Assurance & Testing. Software Testing is his heart and soul and thus he has made immense contribution [...]
Our next Excel drill – counting words in a cell.
As usual, it’s pretty simple. You need to know few functions – LEN, TRIM, SUBSTITUTE
LEN: We’ve covered this in our previous article.
TRIM: Removes all spaces from text except for single spaces between words.
SUBSTITUTE: Substitutes new_text for old_text in a text string.
Before we start, we want to ask [...]
Say you have a use case in which you have to get the first name or last name of employees given that their full names are in a column.
You need to learn just 4 functions – LEN, FIND, LEFT, RIGHT
A one liner about each –
LEN: returns the number of characters in a text string.
FIND: locate one [...]