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

У вашего броузера проблема в совместимости с HTML5

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

Опубликовано: 17-05-2021

Теги: Alternate Drag and Drop Menu in Excel Ann K. Emery Bill Jelen Brad Yundt Copy Here as Values Only menu in Excel Counting words in Excel Excel Functions we need in Excel Microsoft Excel MrExcel SUBSTITUTE and LEN in Excel TEXTJOIN in Excel TEXTSPLIT in Excel excel tips and tricks mr excel space text excel textjoin function

Похожие видео

Excel TEXTSPLIT Alternative With FILTERXML - 235503:52

Four Excel Features To Maybe Avoid - 240807:43

Custom Lists To Fill Excel Data - With Ann K. Emery - 240602:11

UNIQUE on Rectangular Range in Excel - Episode 231709:47

Мой аккаунт

Вход / Log In