MrExcel Excel Videos

This actually applies to any character that you want to display in Excel that is in the Unicode character set. Microsoft gave us functions for UNICODE and UNICHAR. It is not intuitive, but you have to use UNICHAR to solve this. However, the websites showing the unicode are often showing the number in Hex, so you have to use HEX2DEC before passing the value into UNICODE. Table of Contents (0:00) What is gamma and beta (0:13) Results of googling (0:32) History of CODE and CHAR (0:54) UNICODE isn't it (1:22) UNICHAR of HEX2DEC (1:51) Displaying Beta in Excel (2:21) ESPN Wrap up (2:59) Retrieve Webinar (3:30) Episode 2500 ideas?

Microsoft Excel Tutorial: Special ESPN Pricing: https://www.mrexcel.com/news/special-ocho-deals-on-training-books-to-celebrate-excel-being-on-espn/ The Excel All Star Battle will air on ESPN2 at: Friday August 5, 2022 at 5 AM Eastern. (2 AM Pacific. 10 AM in London.) Sunday August 7, 2022 at 9AM Eastern. (6 AM Pacific, Noon in London.) Monday August 8 (8/8!), 2022 at 11:30 PM Eastern. (8:30 PM Pacific - Prime Time, Baby! And 4:30 AM Tuesday in London). Bill's favorite Excel trick: Fast Formula Copy, as well as a lot of other items. Table of Contents (0:00) Historical re-enactment (0:20) Data description (1:00) Begins typing (1:38) Adding text is #VALUE error (1:57) & to Concatenate (2:10) FORMULATEXT function (2:36) Adding a space...

Reid would like to list all 6-number combinations of the numbers 1 to 44. For example, 1-2-3-4-5-6, 1-2-3-4-5-7, and so on up to 39-40-41-42-43-44. The first thing to realize is that all lottery combinations are a lot of numbers. Over 7 million possibilities according to the COMBIN function in Excel. (For Power Ball, there are 292 million combinations!). Listing all combinations will be difficult because Excel only includes 1,048,576 rows. In this video, I show how to enable Macros in your version of Excel and then the macro code to list all possible combinations. Here is the code you can copy into your project. Sub ListThemAll() TC = 1 TR = 1 Ctr = 1 MaxRows = Rows.Count EndCell = 7059052...

ExcelFormulaBot.com is a free A.I. bot that generates the Excel formula for any problem. You type a sentence. It suggests a formula. Free from David Bressler. Table of Contents (0:00) This is cool (0:36) Formula for last word (1:15) Formula for Prime Numbers (2:23) Excel All Star Battle on ESPN8 The Ocho

I love this feature so much, I turned it off! For decades, Excel has been performing default data conversions: Remove leading zeroes Keep first 15 digits of long numbers and convert to scientific notation Convert digits surrounding an E to scientific notation. New in Insiders beta, Excel will ask if you want to do all three of those things. The first time, I was happy to click Don't Convert. But I think the real solution is to embrace all three options and turn all three of them off! They have been annoying us for so long. Why would you want Microsoft to ask, "Hey, should we keep annoying you?". For me, I am turning all three of these off. Table of Contents (0:00) I love this so much, I am turning it off (1:10) Numbers longer than 15...

Episode 2493 Why is the drop-down arrow not showing up when I create the Excel validation with VBA? It appears after I click Save. But I don't want to save since these numbers are a temporary scenario and I plan on closing without saving. Also: Using the Selection Pane in Excel to see all shape names How Excel names shapes. Why Excel renames Shapes during workbook copy How to use VBA to detect which shape was selected. Table of Contents (0:00) Bug with Shapes in VBA (0:31) Excel Validation drop-down arrow missing (3:05) VBA code to delete shapes (4:07) How Excel Names Shapes (4:44) Selection Pane in Excel (5:47) First Validation arrow is named (7:01) Shapes names restart with new sheet (7:48) Shapes renamed after Sheet Copy (9:26) VBA...

Episode 2492 The Calc team at Microsoft released three changes to new functions in late May 2022. The improvements to TEXTBEFORE and TEXTAFTER give you options for dealing with situations where the delimiter that you are searching for is not found. Table of Contents (0:00) Former problem with TEXTBEFORE (0:37) New syntax (1:11) Using Match End (1:31) Using If Not Found (1:47) Why both? (2:12) Thanks Excel Team (2:27) Nancy Faust (2:34) Like & Subscribe (2:41) Excel Video Courses

Episode 2491 - While using SmartRoster software, you try to export a report to Word. The export does not start and you get a message that says, "Microsoft Word Security Notice. Microsoft Office has identified a potential security concern. Microsoft has blocked macros from running because the source of this file is untrusted." I recently posted episode 2485 that attempted to allow macros by using the Unblock checkbox in the workbook properties. That method won't work here. Instead, you can temporarily set up a trusted location. This video shows you how. Table of Contents (0:00) Microsoft is blocking macros from running. (0:53) SmartRoster problem (2:29) Behind the scenes (3:11) Demo of solution (3:45) SmartRoster working again (4:03)...

A new pink bar warning is appearing in Excel, Word, and PowerPoint telling you that there is a security risk and that your VBA macros have been blocked. This warning is designed to make you ask, "Is there a valid reason for this person to be sending me a macro?" If there is, I will show you the easy steps to unblock the workbook. This is called the Mark of the Web. Kevin Lehrbass Word Game is here: Word Game in Excel | My Spreadsheet Lab Table of Contents (0:00) Kevin Lehrbass has a Wordle game in Excel but the macros are blocked with the pink bar. (1:08) Look at the code (1:33) How to unblock the macros (2:10) Dealing with the normal yellow bar.