Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What is the formula to find a word length?

Microsoft Excel Microsoft Office
user-image
Question added by Suhail Mohammed , Sales Coordinator, Procurement Coordinator & Logistics Support , Hoshan Pan Gulf
Date Posted: 2016/10/24
Upvote (0) Views (8) Followers (2) Answers (2) Report Question
Write an Answer
Register now or log in to answer.
Majid Ali Butt
by Majid Ali Butt , Accountant Supervisor , AL-MURTAZA FLOUR & GENERAL MILLS

=LEN(text), counts the length of the text

Irfan Rafi
by Irfan Rafi , Senior Commissioning Engineer , MM Pakistan Pvt. Ltd

If you want to calculate word length of the word in a cell just use formula""LEN(cell No)". But keep in  mind by this formula spaces also be counted as length of the words in a cell.

If you want to calculate without spaces just "LEN(TRIM(cell No))". 

Hope this will help......

Write Your Answer
More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.

Get Help