Combining Text With The CONCAT and TEXTJOIN Excel Functions

Combining Text With The CONCAT and TEXTJOIN Excel Functions

There are a variety of reasons why you might want to combine various cell values into a single value. You might be trying to create a unique ID to perform a lookup or simply wanting to combine location information such as a city with a country. The Microsoft Excel developers have recognized the importance of joining our data inside of Excel and have finally added two more extremely useful functions that we can incorporate into our arsenal of text manipulating skills. In this article, you will learn the basics of combining text with these brand new functions and hopefully you gain some insight into how you can use them inside your spreadsheet work on a regular basis.

Read More

Correcting Shape Assigned Macro Links After Copying Worksheet VBA

Correcting Shape Assigned Macro Links After Copying Worksheet VBA

The easiest way to copy over VBA code while copying your worksheets into a new workbook is to store your VBA macros within the worksheet itself instead of the typical Modules that most people use. While it is possible to copy Modules from one workbook to another, it adds another layer of VBA coding that is much more of a hassle than storing your code within a Worksheet Object.

Read More

Adding Tickmark Indicators To Your Excel Analysis Comments

Adding Tickmark Indicators To Your Excel Analysis Comments

Today, I am going to show you how to easily add indicators to your commentary so your audience (ie the decision-makers) already has the right state of mind before reading a single letter of your comments. This will tremendously help them comprehend your analysis and score you "brownie points", because they will be able to do it in a fraction of the time as well!

Read More

Excel PowerBall Lottery Ticket Checker Spreadsheet

Excel PowerBall Lottery Ticket Checker Spreadsheet

With this Excel-powered spreadsheet you can type in all your lottery ticket picks and automatically get fed winning numbers once the lottery balls have been picked. I'll provide a little bit of how the spreadsheet is setup and then you can download this Excel file for free and use it to analyze the next time your office pulls together $500 bucks for a chance at living the good life.

Read More

Masking (Hiding) A Password As It Is Entered In An Excel Text Box

Masking (Hiding) A Password As It Is Entered In An Excel Text Box

Today, I came across a spreadsheet that allowed a user to connect to a remote database via VBA. The spreadsheet had a nifty little interface allowing you to enter your username and password for access to the database. The thing that caught my eye was the password had masked characters, so no one passing by your desk could see your password.

Read More