top of page
  • Lowell

A Cat Can't Concatenate, But Excel Can


The Excel CONCATENATE function lets you link or string together text and calculations. I use a simple target heart rate formula in the example below to illustrate the CONCATENATE function.


Target heart rate is generally defined as the beneficial beats per minute (BPM) during exercise. It is calculated by subtracting your age from 220 and multiplying the results by 50% and 85% to find your target BPM range.


Please, consult your doctor to determine what's healthy for you.


Below is a screenshot of a simple Excel target heart rate calculation . Your age is entered in cell B1. The maximum heart rate formula “=220-B1” without the quotes is in cell B2. It shows the maximum heart rate for a 72 year-old by subtracting the age from 220. Excel formulas always begin with the = sign.

The formula in cell A3 is:

="Your target heart rate is "&0.5*B2&" to "&0.85*B2 & " BPM"

Note that text is surrounded by beginning and ending quotes - numbers and cell references do not require quotes. Also, notice the space characters after “between,” before and after “to,” and before BPM.


So, where is the word CONCATENATE? The ampersand (&) character represents it. It is much easier to type & than CONCATENATE and I'm less likely to misspell &. The & also shortens formulas, making them easier to read. The expressions “0.5*B2” and 0.85*B2 calculate 50% and 85% of your maximum heart rate. The * means multiplication in Excel.

Finally, notice how, even though the formula is in cell A3, its results spill over into columns B & C. This is normal Excel behavior. If I typed something into cell B3, then cell A3 would display only “Your target heart rate is.”

4 views

Recent Posts

See All

Excel is a Square

Source: https://www.makeuseof.com/turn-excel-cells-into-squares/ Uses: Calendar Grids, Print your own graph paper Here are two ways to create square cells in Excel. In either method, you can begin wit

Excel Can Be Flashy

Excel has an interesting feature in the Data Tools Group of the Data Ribbon. It’s called Flash Fill and I believe it arrived in Excel 2013. You can use the keyboard shortcut Ctrl+E or click the Flash

Sort Excel Data as You Enter

In December 2020, I spent some time writing functions that would allow data to be sorted as I entered it into Excel. Now I've discovered that Excel in my Microsoft 365 subscription has a function that

Comments


bottom of page