Home دروس الاكسيل

كيفية حساب عدد الكلمات داخل خلية في برنامج مايكروسوفت Excel

September 18, 2021

كيفية حساب عدد الكلمات داخل خلية في برنامج مايكروسوفت Excel

في هذه التدوينة سنتعلم كيفية حساب عدد الكلمات داخل خلية في برنامج مايكروسوفت Excel, لكي نفهم جيدا سنبدأ بمثال عن شركة سيارات تريد عمل اعلانات عن شركتها وذالك عبرالايميل.

تريد الشركة حساب تكلفة الاعلان حسب عدد الكلمات في الايميل, لذا سنتعرف في هذا المثال على كيفية حساب عدد الكلمات الموجودة في الايميل من خلال الاكسيل .

لحساب عدد كلمات النص في الايميل سنستخدم المعادلة التالية :

عدد الكلمات = عدد حروف النص - عدد حروف النص بدون مسافات + 1

لحساب عدد حروف النص المستخدم في الايميل سنستخدم المعادلة التالية :

LEN(A2)

لكي نقوم بحساب عدد حروف النص بدون مسافات سنستخدم المعادلة التالية :

=LEN(SUBSTITUTE(A2," ",""))

اذا لاحظتو أننا قمنا باستخدام دالة SUBSTITUTE لكي نقوم بحذف المسافات من النص عن طريق استبدال المسافة " " بنص فارغ ""

بالنسبة للدالة SUBSTITUTE سنتعرف عليها في الدروس اللاحقة.

و اعتمادا على ذلك ستكون المعادلة المستخدمة لحساب عدد كلمات الايميل هي :

=LEN(A2)-LEN(SUBSTITUTE(A2," ",""))+1

كيفية حساب عدد الكلمات داخل خلية في برنامج مايكروسوفت Excel

Tags دروس الاكسيل معادلات إكسيل

Latest articles from : دروس الاكسيل

Comments

No comments

Post a Comment

Reading Mode :

Font Size

+

16

-

lines height

+

2

-

window['__wavt'] = 'AOuZoY4bfR6XTeHFbOfT1hKIrXB1DMznGQ:1714098506189';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d7172743834752994373','//www.practiceexcel-365.com/2021/09/excel_02038162969.html','7172743834752994373'); _WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '7172743834752994373', 'title': 'Practice Excel365 | Free Excel Courses', 'url': 'https://www.practiceexcel-365.com/2021/09/excel_02038162969.html', 'canonicalUrl': 'https://www.practiceexcel-365.com/2021/09/excel_02038162969.html', 'homepageUrl': 'https://www.practiceexcel-365.com/', 'searchUrl': 'https://www.practiceexcel-365.com/search', 'canonicalHomepageUrl': 'https://www.practiceexcel-365.com/', 'blogspotFaviconUrl': 'https://www.practiceexcel-365.com/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': true, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': 'UA-204466697-1', 'encoding': 'UTF-8', 'locale': 'en', 'localeUnderscoreDelimited': 'en', 'languageDirection': 'ltr', 'isPrivate': false, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'isDynamicViewsAvailable': true, 'feedLinks': '\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Practice Excel365 | Free Excel Courses - Atom\x22 href\x3d\x22https://www.practiceexcel-365.com/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22Practice Excel365 | Free Excel Courses - RSS\x22 href\x3d\x22https://www.practiceexcel-365.com/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Practice Excel365 | Free Excel Courses - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/7172743834752994373/posts/default\x22 /\x3e\n\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Practice Excel365 | Free Excel Courses - Atom\x22 href\x3d\x22https://www.practiceexcel-365.com/feeds/1498142789508725818/comments/default\x22 /\x3e\n', 'meTag': '', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': true, 'adsenseAutoAds': false, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/16e657cb9c57b8a2', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': 'Get link', 'key': 'link', 'shareMessage': 'Get link', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Share to Facebook', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': 'Twitter', 'key': 'twitter', 'shareMessage': 'Share to Twitter', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Share to Pinterest', 'target': 'pinterest'}, {'name': 'Email', 'key': 'email', 'shareMessage': 'Email', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27en\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': true, 'jumpLinkMessage': 'Read more \xbb', 'pageType': 'item', 'postId': '1498142789508725818', 'postImageThumbnailUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgAN8TjxtOCaG2X-0h7lNJgI5ZTc7AC8o9yBWzGVQ4YPS0YhpBJqe21V2-nwdEACGHM20jRCVTT8plo-IUKfOCysWzwaFDpYOM2uQCr1BzQdbb8giVTEexj37CQ330HCJTQB4jLRoNkUvI/s72-c/%2526.png', 'postImageUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgAN8TjxtOCaG2X-0h7lNJgI5ZTc7AC8o9yBWzGVQ4YPS0YhpBJqe21V2-nwdEACGHM20jRCVTT8plo-IUKfOCysWzwaFDpYOM2uQCr1BzQdbb8giVTEexj37CQ330HCJTQB4jLRoNkUvI/s16000/%2526.png', 'pageName': '\u0643\u064a\u0641\u064a\u0629 \u062d\u0633\u0627\u0628 \u0639\u062f\u062f \u0627\u0644\u0643\u0644\u0645\u0627\u062a \u062f\u0627\u062e\u0644 \u062e\u0644\u064a\u0629 \u0641\u064a \u0628\u0631\u0646\u0627\u0645\u062c \u0645\u0627\u064a\u0643\u0631\u0648\u0633\u0648\u0641\u062a Excel', 'pageTitle': 'Practice Excel365 | Free Excel Courses: \u0643\u064a\u0641\u064a\u0629 \u062d\u0633\u0627\u0628 \u0639\u062f\u062f \u0627\u0644\u0643\u0644\u0645\u0627\u062a \u062f\u0627\u062e\u0644 \u062e\u0644\u064a\u0629 \u0641\u064a \u0628\u0631\u0646\u0627\u0645\u062c \u0645\u0627\u064a\u0643\u0631\u0648\u0633\u0648\u0641\u062a Excel', 'metaDescription': '\u0641\u064a \u0647\u0630\u0647 \u0627\u0644\u062a\u062f\u0648\u064a\u0646\u0629 \u0633\u0646\u062a\u0639\u0644\u0645 \u0643\u064a\u0641\u064a\u0629 \u062d\u0633\u0627\u0628 \u0639\u062f\u062f \u0627\u0644\u0643\u0644\u0645\u0627\u062a \u062f\u0627\u062e\u0644 \u062e\u0644\u064a\u0629 \u0641\u064a \u0628\u0631\u0646\u0627\u0645\u062c \u0645\u0627\u064a\u0643\u0631\u0648\u0633\u0648\u0641\u062a Excel, \u0644\u0643\u064a \u0646\u0641\u0647\u0645 \u062c\u064a\u062f\u0627 \u0633\u0646\u0628\u062f\u0623 \u0628\u0645\u062b\u0627\u0644 \u0639\u0646 \u0634\u0631\u0643\u0629 \u0633\u064a\u0627\u0631\u0627\u062a \u062a\u0631\u064a\u062f \u0639\u0645\u0644 \u0627\u0639\u0644\u0627\u0646\u0627\u062a \u0639\u0646 \u0634\u0631\u0643\u062a\u0647'}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': 'Edit', 'linkCopiedToClipboard': 'Link copied to clipboard!', 'ok': 'Ok', 'postLink': 'Post Link'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': 'Custom', 'isResponsive': true, 'isAlternateRendering': false, 'isCustom': true}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\x3dclassic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\x3dflipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\x3dmagazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\x3dmosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\x3dsidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\x3dsnapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\x3dtimeslide'}, 'isMobile': false, 'title': '\u0643\u064a\u0641\u064a\u0629 \u062d\u0633\u0627\u0628 \u0639\u062f\u062f \u0627\u0644\u0643\u0644\u0645\u0627\u062a \u062f\u0627\u062e\u0644 \u062e\u0644\u064a\u0629 \u0641\u064a \u0628\u0631\u0646\u0627\u0645\u062c \u0645\u0627\u064a\u0643\u0631\u0648\u0633\u0648\u0641\u062a Excel', 'description': '\u0641\u064a \u0647\u0630\u0647 \u0627\u0644\u062a\u062f\u0648\u064a\u0646\u0629 \u0633\u0646\u062a\u0639\u0644\u0645 \u0643\u064a\u0641\u064a\u0629 \u062d\u0633\u0627\u0628 \u0639\u062f\u062f \u0627\u0644\u0643\u0644\u0645\u0627\u062a \u062f\u0627\u062e\u0644 \u062e\u0644\u064a\u0629 \u0641\u064a \u0628\u0631\u0646\u0627\u0645\u062c \u0645\u0627\u064a\u0643\u0631\u0648\u0633\u0648\u0641\u062a Excel, \u0644\u0643\u064a \u0646\u0641\u0647\u0645 \u062c\u064a\u062f\u0627 \u0633\u0646\u0628\u062f\u0623 \u0628\u0645\u062b\u0627\u0644 \u0639\u0646 \u0634\u0631\u0643\u0629 \u0633\u064a\u0627\u0631\u0627\u062a \u062a\u0631\u064a\u062f \u0639\u0645\u0644 \u0627\u0639\u0644\u0627\u0646\u0627\u062a \u0639\u0646 \u0634\u0631\u0643\u062a\u0647', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgAN8TjxtOCaG2X-0h7lNJgI5ZTc7AC8o9yBWzGVQ4YPS0YhpBJqe21V2-nwdEACGHM20jRCVTT8plo-IUKfOCysWzwaFDpYOM2uQCr1BzQdbb8giVTEexj37CQ330HCJTQB4jLRoNkUvI/s16000/%2526.png', 'url': 'https://www.practiceexcel-365.com/2021/09/excel_02038162969.html', 'type': 'item', 'isSingleItem': true, 'isMultipleItems': false, 'isError': false, 'isPage': false, 'isPost': true, 'isHomepage': false, 'isArchive': false, 'isLabelSearch': false, 'postId': 1498142789508725818}}, {'name': 'widgets', 'data': [{'title': 'BlogArchive', 'type': 'BlogArchive', 'sectionId': 'sitting', 'id': 'BlogArchive400'}, {'title': 'BlogLabels', 'type': 'Label', 'sectionId': 'sitting', 'id': 'Label400'}, {'title': 'Pages', 'type': 'PageList', 'sectionId': 'pages', 'id': 'PageList1'}, {'title': '\u0645\u0648\u0627\u0642\u0639 \u0627\u0644\u062a\u0648\u0627\u0635\u0644 \u0627\u0644\u0625\u062c\u062a\u0645\u0627\u0639\u064a', 'type': 'LinkList', 'sectionId': 'topsocialL', 'id': 'LinkList3'}, {'title': 'Practice Excel365 | Free Excel Courses (Header)', 'type': 'Header', 'sectionId': 'logo', 'id': 'Header1'}, {'title': '\u0627\u0644\u0642\u0627\u0626\u0645\u0629 \u0627\u0644\u0631\u0626\u064a\u0633\u064a\u0629', 'type': 'LinkList', 'sectionId': 'menu', 'id': 'LinkList22'}, {'title': 'Blog Posts', 'type': 'Blog', 'sectionId': 'Tempnec', 'id': 'Blog1', 'posts': [{'id': '1498142789508725818', 'title': '\u0643\u064a\u0641\u064a\u0629 \u062d\u0633\u0627\u0628 \u0639\u062f\u062f \u0627\u0644\u0643\u0644\u0645\u0627\u062a \u062f\u0627\u062e\u0644 \u062e\u0644\u064a\u0629 \u0641\u064a \u0628\u0631\u0646\u0627\u0645\u062c \u0645\u0627\u064a\u0643\u0631\u0648\u0633\u0648\u0641\u062a Excel', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgAN8TjxtOCaG2X-0h7lNJgI5ZTc7AC8o9yBWzGVQ4YPS0YhpBJqe21V2-nwdEACGHM20jRCVTT8plo-IUKfOCysWzwaFDpYOM2uQCr1BzQdbb8giVTEexj37CQ330HCJTQB4jLRoNkUvI/s16000/%2526.png', 'showInlineAds': true}], 'headerByline': {'regionName': 'header1', 'items': [{'name': 'share', 'label': ''}, {'name': 'timestamp', 'label': '-'}]}, 'footerBylines': [{'regionName': 'footer1', 'items': [{'name': 'comments', 'label': 'comments'}, {'name': 'icons', 'label': ''}]}, {'regionName': 'footer2', 'items': [{'name': 'labels', 'label': ''}]}], 'allBylineItems': [{'name': 'share', 'label': ''}, {'name': 'timestamp', 'label': '-'}, {'name': 'comments', 'label': 'comments'}, {'name': 'icons', 'label': ''}, {'name': 'labels', 'label': ''}]}, {'title': 'Contact Form', 'type': 'ContactForm', 'sectionId': 'AddOns', 'id': 'ContactForm200'}, {'title': '\u0645\u0648\u0627\u0642\u0639 \u0627\u0644\u062a\u0648\u0627\u0635\u0644 \u0627\u0644\u0625\u062c\u062a\u0645\u0627\u0639\u064a', 'type': 'LinkList', 'sectionId': 'sidepar', 'id': 'LinkList4'}, {'title': '\u0645\u0648\u0627\u0642\u0639 \u0627\u0644\u062a\u0648\u0627\u0635\u0644 \u0627\u0644\u0625\u062c\u062a\u0645\u0627\u0639\u064a', 'type': 'LinkList', 'sectionId': 'footer-social', 'id': 'LinkList2'}]}]); _WidgetManager._RegisterWidget('_BlogArchiveView', new _WidgetInfo('BlogArchive400', 'sitting', document.getElementById('BlogArchive400'), {'languageDirection': 'ltr', 'loadingMessage': 'Loading\x26hellip;'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label400', 'sitting', document.getElementById('Label400'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_PageListView', new _WidgetInfo('PageList1', 'pages', document.getElementById('PageList1'), {'title': 'Pages', 'links': [{'isCurrentPage': false, 'href': 'http://www.practiceexcel-365.com/', 'title': 'Home'}, {'isCurrentPage': false, 'href': 'https://www.practiceexcel-365.com/p/privacy-policy.html', 'id': '9039293699451073275', 'title': 'Privacy Policy'}, {'isCurrentPage': false, 'href': 'https://www.practiceexcel-365.com/p/who-are-we.html', 'id': '3848084781500635721', 'title': 'Who We Are'}, {'isCurrentPage': false, 'href': 'https://www.practiceexcel-365.com/p/contact-us.html', 'id': '5696516493396065643', 'title': 'Contact Us'}, {'isCurrentPage': false, 'href': 'https://www.practiceexcel-365.com/p/blog-page.html', 'id': '4724947008150640905', 'title': 'Frequently Asked Questions'}], 'mobile': false, 'showPlaceholder': true, 'hasCurrentPage': false}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList3', 'topsocialL', document.getElementById('LinkList3'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HeaderView', new _WidgetInfo('Header1', 'logo', document.getElementById('Header1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList22', 'menu', document.getElementById('LinkList22'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog1', 'Tempnec', document.getElementById('Blog1'), {'cmtInteractionsEnabled': false, 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/1666805145-lbx.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/13464135-lightbox_bundle.css'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_ContactFormView', new _WidgetInfo('ContactForm200', 'AddOns', document.getElementById('ContactForm200'), {'contactFormMessageSendingMsg': 'Sending...', 'contactFormMessageSentMsg': 'Your message has been sent.', 'contactFormMessageNotSentMsg': 'Message could not be sent. Please try again later.', 'contactFormInvalidEmailMsg': 'A valid email address is required.', 'contactFormEmptyMessageMsg': 'Message field cannot be empty.', 'title': 'Contact Form', 'blogId': '7172743834752994373', 'contactFormNameMsg': 'Name', 'contactFormEmailMsg': 'Email', 'contactFormMessageMsg': 'Message', 'contactFormSendMsg': 'Send', 'contactFormToken': 'AOuZoY7n4UoB8HvW7r8kwakbL7J5ALknUg:1714098506189', 'submitUrl': 'https://www.blogger.com/contact-form.do'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList4', 'sidepar', document.getElementById('LinkList4'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList2', 'footer-social', document.getElementById('LinkList2'), {}, 'displayModeFull'));