Rod from Cincinati asks how to solve the problem of trailing spaces in the lookup table. I had never tried it before, but you can apply a TRIM to the entire lookup table. Episode 1138 shows you how.
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!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
MrExcel Excel Videos
Learn Excel from MrExcel - Excel tips and tricks from Bill Jelen.
Filters
Show only:
Loading…
If you need to find a unique list of values in any column, there are a couple of ways to find the unique values in a column. Episode 364 shows you how.
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
When you copy and paste data from a web browser to Excel, a number of maddening settings come along with the data. In Episode 362, I will show you how to turn off the wrap text feature and get the columns wide enough to fit the data.
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
Bruce from Texas calls in today with an Excel problem. Bruce needs to turn a worksheet on its side, moving the rows to columns and columns to row. Episode 361 shows you how.
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
Today on Episode 360, a viewer question stumps MrExcel. Well, there are two solutions in the podcast, but like you, I have to believe there is a better way. The question is how to add a page break every 35 rows. If you know a better way to do this, leave a message at 866-581-0221.
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
Create cool headlines by adding text to your autoshape and then formatting it using the drawing toolbar. Episode 369 shows you how.
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
