Like us on Facebook
Follow us on Twitter

Categories

22 yrs in IT, An Entrepreneur, A Trainer & Consultant of S/W Testing: Meet Shiva

Shiva

 

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 [...]

Count Words In A Cell

cnt_wrds1

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 [...]

Segregate Words from a String

ex_name1

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 [...]

Page 1 of 3112345...102030...Last »