Bill Jelen

Learn Excel – “eBay Gallery Concatenate Image Names”: Podcast #1865


Dale needs to upload listings to eBay. One of the tough fields is the Gallery field, where the names of several images need to be in a single Cell separated by Back

Dueling Excel – “List All Day Numbers In A Date Range”: Podcast #1864


Given a start date and an end date, how do we produce a list of all the Day Numbers? For example, between Feb 28 and March 5 Back

Learn Excel – “Excel HEL: Go 3000 Columns To Right”: Podcast #1863


James T asks if the Ctrl+G Dialog Box provides a way to jump 3000 columns to the right. (After all, Column E + 3000 columns is what? Back

Learn Excel – “Password to Open Excel File”: Podcast #1862


Chuck from Florida asks how to require a Password to open an Excel file. Using Protect Workbook does NOT solve this question, but Back

Learn Excel – “VLOOKUP to 3 Sheets”: Podcast #1861


Latasha asks how to use ‘VLOOKUP’ into three Worksheets. Her product number might be found on the master product list, but it might be Back

Learn Excel from MrExcel