Learn Excel – A Better Concatenate: Podcast #1375
Today, in Episode #1375, Bill looks at the =CONCATENATE Function in Microsoft Excel. Why doesn’t the =CONCATENATE function accept a range? Why can’t you specify a separator character? It is not that hard. Today’s episode shows a simple macro using a defined function that would solve the problem.
…This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
For more Excel 2010 knowledge, check out “Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.
“The Learn Excel from MrExcel Podcast Series”
MrExcel.com — Your One Stop for Excel Tips and Solutions.
Entry filed under: Learn Excel 97-2007, Learn Excel from MrExcel, MrExcel Podcast, MrExcel Products. Tags: 2007, 2010, accounting, Bill Jelen, business, Concatenate, Concatenate Text, Data, Excel, Excel 2007, Excel 2010, Functions, Join Text, Joining Text in Excel, Macro, MrExcel, spreadsheets, technology, Text, tutorial, User Defined, VBA, Worksheet.