{"id":963,"date":"2022-01-09T12:01:00","date_gmt":"2022-01-09T17:01:00","guid":{"rendered":"https:\/\/spreadsheet-day.com\/blog\/?p=963"},"modified":"2022-01-09T11:57:23","modified_gmt":"2022-01-09T16:57:23","slug":"make-a-word-cloud-in-excel","status":"publish","type":"post","link":"https:\/\/spreadsheet-day.com\/blog\/2022\/01\/09\/make-a-word-cloud-in-excel\/","title":{"rendered":"Make a Word Cloud in Excel"},"content":{"rendered":"<div class=\"d942c2121bfbd137a3b44056a000f09c\" data-index=\"1\" style=\"float: none; margin:10px 0 10px 0; text-align:center;\">\n<script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\r\n<!-- Responsive Top -->\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block\"\r\n     data-ad-client=\"ca-pub-9531091850463532\"\r\n     data-ad-slot=\"6574318169\"\r\n     data-ad-format=\"auto\"><\/ins>\r\n<script>\r\n(adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<p>Happy Word Nerd Day! When people think about spreadsheets, they usually think of numbers, formulas and calculations. But spreadsheets are great at organizing words too! Here are a few of the functions you can use with text, and a fun word cloud tool to try.<\/p>\n<p><!--more--><\/p>\n<h3>Fun Word Cloud Tool<\/h3>\n<p>Are you ready for some fun with words in a spreadsheet? Robert Mundigl build an Excel workbook that lets you <a href=\"http:\/\/www.clearlyandsimply.com\/clearly_and_simply\/2015\/02\/word-clouds-with-microsoft-excel.html\">create word clouds in Excel<\/a>, so I downloaded his sample file, and tried it out.&nbsp;<\/p>\n<p>There&#8217;s a generic example, but I got the file that&#8217;s filled with Bruce Springsteen lyrics. It sounded like more fun, and easier than inputting my own word list.<\/p>\n<p>The sample file had a light grey background for the word cloud, with Lucinda font in green text, and I found that hard to read.<\/p>\n<p><a href=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2022\/01\/wordcloud_excel03.png\"><img loading=\"lazy\" decoding=\"async\" title=\"word cloud in Excel hard to read\" style=\"border: 0px currentcolor; border-image: none; display: inline; background-image: none;\" alt=\"word cloud in Excel hard to read\" src=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2022\/01\/wordcloud_excel03_thumb.png\" width=\"375\" height=\"371\" border=\"0\"><\/a><\/p>\n<h3>Change the Word Cloud Settings<\/h3>\n<p>Fortunately, Robert made it easy to change all the settings, right on the main worksheet.<\/p>\n<p>So I switched to Impact font, in black, with a larger font size.<\/p>\n<p><a href=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2022\/01\/wordcloud_excel02.png\"><img loading=\"lazy\" decoding=\"async\" title=\"word cloud settings in Excel\" style=\"border: 0px currentcolor; border-image: none; display: inline; background-image: none;\" alt=\"word cloud settings in Excel\" src=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2022\/01\/wordcloud_excel02_thumb.png\" width=\"325\" height=\"355\" border=\"0\"><\/a><\/p>\n<h3>Create the Word Cloud<\/h3>\n<p>After you&#8217;ve changed the word cloud settings, it&#8217;s easy to create your new word cloud in Excel.<\/p>\n<ul>\n<li>At top of the worksheet, select a song from the drop down list.<\/li>\n<\/ul>\n<p>I chose the song, Born to Run, and here&#8217;s the word cloud for that song.<\/p>\n<p>The word &#8220;Born&#8221; is in the song&#8217;s title, but it&#8217;s certainly not prominent in the word cloud! Can you find it?<\/p>\n<p><a href=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2022\/01\/wordcloud_excel01.png\"><img loading=\"lazy\" decoding=\"async\" title=\"word cloud for born to run\" style=\"border: 0px currentcolor; border-image: none; display: inline; background-image: none;\" alt=\"word cloud for born to run\" src=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2022\/01\/wordcloud_excel01_thumb.png\" width=\"463\" height=\"456\" border=\"0\"><\/a><\/p>\n<h3>Word Cloud Word Counts<\/h3>\n<p>On another sheet, Robert has a list of the words from each song, with a word count.<\/p>\n<p>In that list, I used the filter, and found &#8220;born&#8221;, way down the list, with a count of 3.<\/p>\n<p><a href=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2022\/01\/wordcloud_excel05.png\"><img loading=\"lazy\" decoding=\"async\" title=\"word count list for born to run\" style=\"border: 0px currentcolor; border-image: none; display: inline; background-image: none;\" alt=\"word count list for born to run\" src=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2022\/01\/wordcloud_excel05_thumb.png\" width=\"365\" height=\"314\" border=\"0\"><\/a><\/p>\n<h3>Check the Word Cloud Again<\/h3>\n<p>With that word count information, I knew that &#8220;born&#8221; would be one of the smallest words in the word cloud, so I looked again. Finally, I found &#8220;born&#8221; at the left side of the chart.<\/p>\n<p>And here&#8217;s a fun feature \u2013 if you point to a word, a tool tip appears, showing the word and the word count!<\/p>\n<p><a href=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2022\/01\/wordcloud_excel04.png\"><img loading=\"lazy\" decoding=\"async\" title=\"word cloud with tooltip\" style=\"border: 0px currentcolor; border-image: none; display: inline; background-image: none;\" alt=\"word cloud with tooltip\" src=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2022\/01\/wordcloud_excel04_thumb.png\" width=\"326\" height=\"277\" border=\"0\"><\/a><\/p>\n<h3>Excel TEXTJOIN Function<\/h3>\n<p>When it&#8217;s time to stop playing with the word cloud, and get back to work, there are lots of Excel functions and formulas that will help you work with words.<\/p>\n<p>I love the new TEXTJOIN function, in Excel 365, that makes it easy to combine the contents of multiple cells.<\/p>\n<p>This short video shows a couple of TEXTJOIN examples, and there are <a href=\"https:\/\/www.contextures.com\/xlcombine01.html#textjoin\" target=\"_blank\" rel=\"noopener\">written steps, and more examples, on my Contextures site<\/a>.<\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/9SrKn1tDSaw?rel=0\" allowfullscreen=\"\" allow=\"autoplay; encrypted-media\" loading=\"lazy\" width=\"450\" height=\"283\" frameborder=\"0\"><\/iframe><\/p>\n<h3>Combine Text and Numbers<\/h3>\n<p>If your version of Excel doesn&#8217;t have TEXTJOIN, you can use the &amp; operator to combine data from two or more cells.<\/p>\n<p>Also, you can use the TEXT function, to format the numbers, so they&#8217;re easy to read in the combined text string.<\/p>\n<p>This short video shows how to do that, and there are <a href=\"https:\/\/www.contextures.com\/xlcombine01.html\" target=\"_blank\" rel=\"noopener\">written steps and more examples on my Contextures site<\/a>.<\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/_eG1xaRr5EE?rel=0\" allowfullscreen=\"\" allow=\"autoplay; encrypted-media\" loading=\"lazy\" width=\"450\" height=\"283\" frameborder=\"0\"><\/iframe><\/p>\n<p>_______________________<\/p>\n<h3>Make a Word Cloud in Excel<\/h3>\n<p>Excel word cloud with words from Springsteen song<\/p>\n<p><a href=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2022\/01\/wordcloudexcel01a.jpg\"><img loading=\"lazy\" decoding=\"async\" title=\"Word cloud with words from Springsteen song\" style=\"border: 0px currentcolor; border-image: none; display: inline; background-image: none;\" alt=\"Word cloud with words from Springsteen song\" src=\"https:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2022\/01\/wordcloudexcel01a_thumb.jpg\" width=\"400\" height=\"400\" border=\"0\"><\/a><\/p>\n<p>_______________________<\/p>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>Happy Word Nerd Day! When people think about spreadsheets, they usually think of numbers, formulas and calculations. But spreadsheets are great at organizing words too! Here are a few of the functions you can&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":961,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-963","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-spreadsheets"],"_links":{"self":[{"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/posts\/963","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/comments?post=963"}],"version-history":[{"count":2,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/posts\/963\/revisions"}],"predecessor-version":[{"id":965,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/posts\/963\/revisions\/965"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/media\/961"}],"wp:attachment":[{"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/media?parent=963"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/categories?post=963"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/tags?post=963"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}