filmov
tv
Excel Textjoin Function
Показать описание
Excel has always done a good job of exporting lists to comma-separated values (CSV files). Starting with the 365 editions, it can also create CSV lists inside the cells of a worksheet. And the data in the lists don’t have to be separated by commas. You can separate them with any delimiter you want, like spaces, colons, or semicolons. In this episode, we use the Textjoin function to take a list of names and addresses and turn them into a column of CSVs. We will also look at a formatting bug the function has.
About Bob:
Bob Flisser has been a software trainer since the mid-1990s, specializing in the Microsoft and Adobe suites. He has written and recorded video courses for LinkedIn Learning, Pluralsight, Skillsoft, Tuts+, and others, and is the co-author of a dozen books of tips and shortcuts for Microsoft applications. He has also written magazine articles and training manuals and set up corporate training centers.
Connect with Bob:
Learn more about Experts Exchange:
#exceltutorial #msexcel #excelhacks
About Bob:
Bob Flisser has been a software trainer since the mid-1990s, specializing in the Microsoft and Adobe suites. He has written and recorded video courses for LinkedIn Learning, Pluralsight, Skillsoft, Tuts+, and others, and is the co-author of a dozen books of tips and shortcuts for Microsoft applications. He has also written magazine articles and training manuals and set up corporate training centers.
Connect with Bob:
Learn more about Experts Exchange:
#exceltutorial #msexcel #excelhacks