TEXT Functions — CONCAT and UPPER

PivotTables and charts read clean headers. A consistent ENGLISH — Q1 label helps when you paste budget notes into emails or governor slides.

James Okonkwo builds readable labels on NorthgateBudget.xlsx without retyping department names five times — formulas pull from column A and quarter headers in row 1.

Text values are labels and joined strings. You cannot SUM a CONCAT column — keep amounts in B2:E6; use labels in helper columns only.

=CONCAT(A2," — ",B1) joins text from cells with punctuation between.

Example: English in A2 and Q1 in B1 → English — Q1 in the formula cell.

In Microsoft 365 you can also write =A2 & " — " & B1 with the & operator.

Example: =A2 & " Budget" in M2 returns English Budget — same result as CONCAT with fewer keystrokes on short joins.

On Budgets, click L1 and type Label. Click L2. Type =CONCAT(A2," — Q1") and press Enter.

Expected result: English — Q1 appears in L2. Copy L2 down through L6 for each department's Q1 label variant.

For dynamic quarter names from B1, use =CONCAT(A2," — ",B1) in a helper row instead.

If you type =CONCAT(A2, —, B1) without quotes around —, Excel expects a cell reference named — and shows #NAME?. Wrap literal text in double quotes: " — ".

=UPPER(A1) returns all capitals: DEPARTMENT.

Useful when imported data has inconsistent capitalisation.

Click an empty cell (e.g. M1). Type =UPPER(A1) assuming A1 holds Department. Expected result: DEPARTMENT — a draft title for a printed cover sheet.

James Okonkwo sometimes copies labels into Word for the budget narrative. CONCAT keeps department and quarter in sync — change A4 from Science to Sciences and every label updates.

Home → Clipboard → Copy the label column after formulas calculate. Paste Values Only in Word if you do not need live links.