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