Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Excel TEXTJOIN And The Need For TEXTSPLIT with Ann K. Emery – 2407

Posted on by Bb

More of my discussion with Ann K. Emery. This episode talks about TEXTJOIN and how it would be nice to have TEXTSPLIT. Check out Ann’s blog at https://depictdatastudio.com/blog/
More Snippets here:
(0:00) Welcome and intro
(0:30) Discussion about TEXTJOIN and TEXTSPLIT
(1:01) Demo of TEXTJOIN using a range in Excel
(1:35) Generating random Yes/No using RAND in Excel
(1:54) Converting Excel formulas to values by dragging
(2:20) Using TEXTJOIN with an IF Function in Excel
(3:00) The need for TEXTSPLIT
(3:10) Counting names using LEN and SUBSTITUTE
(3:40) Converting Excel data to a paragraph in Word
(4:06) Concatenating text and numbers in Excel loses formatting

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.

MrExcel.comTue, August 10, 2021 2:08am