In Today's Podcast, Episode #1373, Ram is using =CLEAN to get rid of the hard-return in a cell, but when he does this, he is losing the space between the words in that cell. Bill shows us how to use the =SUBSTITUTE function instead to yield a better result.

…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.

Today, Greg asks how to line up two reports that don't have similar column widths. Though this can be difficult, in Episode #1372 Bill shows us how to use the Paste Picture Link to solve this particular 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.

Hyperlink haters will relish this episode! Today, in Episode #1371, I cover the following hyperlink topics:

• Deleting one hyperlink
• Deleting a range of hyperlinks with Excel 2010 new features.
• Deleting all hyperlinks with a 1-line macro
• How to stop Excel from creating the hyperlinks in the first place.

Solve all of your hyperlink angst in 4 minutes! Watch Episode #1371 of the "Learn Excel from MrExcel Podcast" Series.

…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.

Dave R shared a great hyperlink tip with Bill. Today, in Episode #1370, Bill shares that tip with us! Build a Hyperlink with an email address; Use the =HYPERLINK Function, Concatenate your information and then click the link! It's simple and Bill shows us how to do it.

…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!

“The Learn Excel from MrExcel Podcast Series”

For all of your Microsoft Excel needs visit MrExcel.com — Your One Stop for Excel Tips and Solutions.

Today's Dueling Excel Podcast, Episode #1369, Looks at creating Data Bars. Under the Conditional Formatting menu, 'Data Bars' became a feature in as of Excel 2007; in Excel 2010 it is a little bit further developed. But what happens if you would like to work with Data Bars in a version of Excel other than 2007 or 2010? Check out today's Dueling Excel Podcast to learn about the =REPT Function to create a Data Bar set in an early version of Excel.

Dueling Excel Podcast #72…This episode is the video podcast companion to the book, “Slaying Excel Dragons: A Beginners Guide to Conquering Excel’s Frustrations and Making Excel Fun“, by Mike Girvin and Bill Jelen.

AND

“Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions.

Joe Z asks how to have the Min and Max values in a Chart Axis change in response to the data being charted. Today, in Episode #1367, Bill shows you how to make it happen in Excel!

…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!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions.

Wyatt asks if there is a way to have SmartArt float above a worksheet and always stay in view. Today, in Episode #1366, Bill shows us how to create a short macro to solve the problem, although not perfectly.

Today we look at a question posed in Episode #1358 "How did Mike and Bill predict the Super Bowl winner?" Bill gives us the answer in Episode #1365 - and announces the winner of the contest.

Today's Dueling Excel, with Mike "ExcelIsFun" Girvin and Bill "MrExcel" Jelen looks at selecting specific entries in a row and then concatenating those entries in one cell. Episode #1364 shows the use of the =INDEX Function plus a few others to get the results.

Dueling Excel Podcast #71…This episode is the video podcast companion to the book, “Slaying Excel Dragons: A Beginners Guide to Conquering Excel’s Frustrations and Making Excel Fun“, by Mike Girvin and Bill Jelen. [Currently available as an eBook / Print Edition due soon!!]

AND

“Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions.

When should you use the Insert Hyperlink compared to the =HYPERLINK() function? Today, in Episode #1363, Bill will compare the two methods. This episode will also show you how to build 100's of hyperlinks by concatenating together some text in quotes with values in a column.

…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!

“The Learn Excel from MrExcel Podcast Series”

For all of your Microsoft Excel needs visit MrExcel.com — Your One Stop for Excel Tips and Solutions.

Ok, so you have a list of hyperlinks in your workbook and now you need to extract the actual URL Addresses of those links . . . How do you do that?
Today, in Episode #1362, Bill shows us how to paste links with the 'Friendly Name', and then extract the actual 'URL' from the link. Also learn how to easily remove unwanted buttons, images and graphics that are inadvertently copied into your workbook.

…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!

“The Learn Excel from MrExcel Podcast Series”

For all of your Microsoft Excel needs visit MrExcel.com — Your One Stop for Excel Tips and Solutions.

Today, Bill continues to look at Hyperlinks in Microsoft Excel. Ever notice that when you paste a column of website addresses into Excel, none of them automatically turn into a hyperlink? This episode [Episode #1361] looks at a couple of solutions to make your hyperlinks hot [ready to be clicked and followed].

…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!

“The Learn Excel from MrExcel Podcast Series”

For all of your Microsoft Excel needs visit MrExcel.com — Your One Stop for Excel Tips and Solutions.

Today's Question: "How can I select a cell that contains an active hyperlink without actually clicking and following the hyperlink?" Bill shows us two solutions in Episode #1360.

…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!

“The Learn Excel from MrExcel Podcast Series”

For all of your Microsoft Excel needs visit MrExcel.com — Your One Stop for Excel Tips and Solutions.

Another Dueling Podcast and Bill thinks he has a 'killer solution' for this one - lets find out! Today, in Episode #1359, Mike 'ExcelIsFun' Girvin and Bill 'MrExcel' Jelen find solutions that will Round Dollars to two (2) decimals, but Round Crude to four (4) Decimals. This Dueling Excel Podcast shows three (3) methods using IF, VLOOKUP or Conditional Formatting.

Dueling Excel Podcast #70…This episode is the video podcast companion to the book, “Slaying Excel Dragons: A Beginners Guide to Conquering Excel’s Frustrations and Making Excel Fun“, by Mike Girvin and Bill Jelen. [Currently available as an eBook / Print Edition due soon!!]

AND

“Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions.