AaText20 min read ·

How to Concatenate in Excel (&, CONCAT and TEXTJOIN)

Learn how to concatenate in Excel with &, CONCAT and TEXTJOIN. Add spaces, commas and line breaks, skip blank cells, and keep dates and numbers formatted.

Quick answer

=TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...)

Join text with the & operator, like =A2&" "&B2, or with CONCAT. To put a separator between every cell in a range and skip the empty ones, use =TEXTJOIN(", ", TRUE, A2:A6), and wrap dates and numbers in TEXT to keep their format.

Arguments in [brackets] are optional.

On this page ⌄
  1. Join text with the & operator
  2. Add a space, comma or other separator
  3. Combine text with CONCAT
  4. CONCAT vs CONCATENATE
  5. Join a range with TEXTJOIN
  6. Skip blank cells with TEXTJOIN
  7. Join a whole column into one cell
  8. Join only the values that match a condition
  9. Clean messy text before you join it
  10. Add a line break with CHAR(10)
  11. Keep dates and numbers formatted with TEXT
  12. Add quotation marks to joined text
  13. Combine cells without a formula: Flash Fill
  14. Turn the results into values
  15. Common mistakes when concatenating
  16. Frequently asked questions about concatenating in Excel
  17. Which versions of Excel have CONCAT and TEXTJOIN?
  18. Key takeaways

To concatenate in Excel, join the pieces with the & operator. Any text you add, such as a space or a comma, goes in double quotes. CONCAT does the same job as a function, and TEXTJOIN puts a separator between every cell in a range for you:

=D4&" "&B4→ FB-2026-0033 [email protected]
=CONCAT(D4, " ", B4)→ FB-2026-0033 [email protected]
=TEXTJOIN("; ", TRUE, B4:B6)→ [email protected]; [email protected]; [email protected]

CONCATENATE is the older version of CONCAT, kept so old workbooks still work. This guide covers all four, plus the jobs that trip people up: messy source data, line breaks, dates and prices that turn into plain numbers, joining only the values that match a condition, and combining cells without a formula.

The examples use this customer export in A1:D6, the same one as the TRIM guide and the split names guide:

A: Full nameB: EmailC: PhoneD: Order code
2emma JOHNSON[email protected](555) 201-4433NW-2026-0187
3liam o'brien[email protected]555.388.1902CT-2025-0942
4OLIVIA chen[email protected]555-647-2210FB-2026-0033
5noah patel[email protected](555) 903 7751NW-2026-0451
6Sofia Martinez[email protected]555 412 0098AW-2024-1120

The names are messy on purpose. A2 has two spaces before emma, three between the words and one after JOHNSON. A4 ends with two spaces, and A5 has three spaces between noah and patel. You can't see the spaces in the table, but joining keeps every one of them.

A few examples also use the date, total and coupon code of each order, in H1:J6:

H: Order dateI: TotalJ: Coupon
2Mar 9, 2026$1,250.00SPRING10
3Nov 14, 2025$89.50
4Jan 6, 2026$4,310.75FREESHIP
5Jun 2, 2026$640.00
6Dec 1, 2024$2,075.20

Column H holds real Excel dates, and column I holds numbers formatted as currency. Only two orders used a coupon, so J3, J5 and J6 are empty.

Join text with the & operator

The & sign, called an ampersand, joins two values into one text. Put it between every piece you want to join:

=D3&B3→ [email protected]

The pieces run together, because & adds nothing between them. Anything you want in between is a piece of its own. Text you type goes in double quotes, so a space is " ":

=D3&" "&B3→ CT-2025-0942 [email protected]

Read it as three pieces: D3, a space and B3, with an & between each pair. You can join as many pieces as you like, mixing cells, typed text and other functions:

="Order "&D3&" was placed by "&PROPER(A3)→ Order CT-2025-0942 was placed by Liam O'Brien

Look at the spaces inside the quotes: one after Order, and one on each side of was placed by. Without them, the words stick to the code and the name. PROPER fixes the capitals of the name before it's joined.

To combine every row, type the formula in the first row and copy it down. In Microsoft 365 and Excel 2021 or later, & also accepts whole ranges and joins them row by row. =D2:D6&" "&C2:C6 spills five results into the cells below, from NW-2026-0187 (555) 201-4433 in the first row to AW-2024-1120 555 412 0098 in the last.

The result of & is always text, even when every piece is a number. =5&5 returns the text 55, not 10.

Add a space, comma or other separator

A separator is just text in quotes, so it can be anything. Here are the same two cells joined four ways:

FormulaResult
=D5&" "&B5NW-2026-0451 [email protected]
=D5&", "&B5NW-2026-0451, [email protected]
=D5&" / "&B5NW-2026-0451 / [email protected]
=D5&" ("&B5&")"NW-2026-0451 ([email protected])

A comma usually needs a space after it, so the separator is ", ", with the space inside the quotes. The brackets in the last row are two separators: " (" before the email and ")" after it.

To put the same separator between many cells, typing it again and again gets old fast. TEXTJOIN takes it once.

Combine text with CONCAT

CONCAT joins its arguments in order. Each one can be a cell, a range, text in quotes or another formula, up to 253 of them:

=CONCAT(text1, [text2], ...)

With single cells, it works like &, with commas instead of & signs:

=CONCAT(D4, ": ", B4)→ FB-2026-0033: [email protected]

Unlike &, CONCAT joins a whole range into one text. That's also where it falls short, because it has no separator:

=CONCAT(D2:D4)→ NW-2026-0187CT-2025-0942FB-2026-0033
=CONCAT(J2:J6)→ SPRING10FREESHIP

The codes run together, and the empty coupon cells add nothing. For a range with a comma or a space between the items, use TEXTJOIN instead.

CONCAT is at its best when you want no separator at all, such as when you build a short ID from parts of a code. This one takes the store, the last two digits of the year and the order number from D5:

=CONCAT(LEFT(D5, 2), MID(D5, 6, 2), RIGHT(D5, 4))→ NW260451

LEFT, MID and RIGHT each pull out one part, and CONCAT glues them together. The LEFT, RIGHT and MID guide explains how each one counts characters.

CONCAT vs CONCATENATE

CONCATENATE is the function CONCAT replaced. It still works in every version of Excel, so old workbooks keep working, but Microsoft suggests using CONCAT from now on, because CONCATENATE may not be available in future versions. With single cells, the two give the same result:

=CONCATENATE(D4, ": ", B4)→ FB-2026-0033: [email protected]

The difference is ranges. CONCATENATE needs each cell as an argument of its own, as in =CONCATENATE(D2, D3, D4). Give it a range and it doesn't join anything. In Microsoft 365, =CONCATENATE(D2:D4) spills the three codes into three cells, unjoined. In Excel 2019 and older, it returns #VALUE!, or only the code in the formula's own row.

Here's how the four ways compare:

&CONCATENATECONCATTEXTJOIN
Joins a range into one textNoNoYesYes
SeparatorTyped between every pairTyped between every pairTyped between every pair, and none inside a rangeTyped once
Skips empty cellsNoNoEmpty cells add nothingYes, with TRUE
Works inEvery versionEvery versionExcel 2019 or later, Microsoft 365Excel 2019 or later, Microsoft 365

In practice, use & to join a few pieces, especially when some are typed text. Use TEXTJOIN for a range or a list with a separator, and CONCAT for a range without one. There's no reason to write new CONCATENATE formulas: & does the same job in every version and is shorter to type.

Join a range with TEXTJOIN

TEXTJOIN joins a range and puts the same separator, the delimiter, between the items:

=TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...)
ArgumentWhat it meansExample
delimiterThe text to put between the items, in quotes. "" means nothing"; "
ignore_emptyTRUE skips empty cells. FALSE keeps them and adds a separator for eachTRUE
text1The first item: a range, a cell, text in quotes or a formulaB2:B6
text2, ...Optional. More items, up to 252 in allC2

Say you want to email every customer at once. Outlook puts a semicolon between addresses, so join the email column with a semicolon and a space:

Copy the cell, paste it into the To line, and all five addresses are there. TEXTJOIN only puts the delimiter between items, never after the last one, so there's no stray semicolon at the end.

A range can run across a row too. This joins the email, phone and order code from row 3:

=TEXTJOIN(" | ", TRUE, B3:D3)→ [email protected] | 555.388.1902 | CT-2025-0942

You can also mix ranges, cells and typed text as separate items, as in =TEXTJOIN(", ", TRUE, B3, C3, "no coupon"). The delimiter goes between all of them.

Skip blank cells with TEXTJOIN

Which coupon codes were used? Point TEXTJOIN at the coupon column, with TRUE as the second argument:

=TEXTJOIN(", ", TRUE, J2:J6)→ SPRING10, FREESHIP

With FALSE, TEXTJOIN keeps the three empty cells and adds a separator for each one:

=TEXTJOIN(", ", FALSE, J2:J6)→ SPRING10, , FREESHIP, ,

That's an empty item between the two codes and two more at the end. =J2&", "&J3&", "&J4&", "&J5&", "&J6 gives the same untidy result, which is why TEXTJOIN with TRUE is the usual way to combine cells with a comma when some are blank.

TRUE also skips formulas that return empty text, "". That's what makes the IF version below work. A cell that holds a space isn't empty, though. TEXTJOIN keeps it as an item and adds a separator. If your data might have cells like that, trim the range inside TEXTJOIN, as in =TEXTJOIN(", ", TRUE, TRIM(J2:J6)), so they become empty text and get skipped.

Join a whole column into one cell

TEXTJOIN with TRUE skips empty cells, so you can point it at more rows than you have. =TEXTJOIN("; ", TRUE, B2:B500) joins the five emails now and picks up new ones as you add them below.

To list each value once, put UNIQUE inside TEXTJOIN. Which stores have orders? LEFT returns the five store codes, NW twice, and UNIQUE drops the repeat:

=TEXTJOIN(", ", TRUE, UNIQUE(LEFT(D2:D6, 2)))→ NW, CT, FB, AW
=TEXTJOIN(", ", TRUE, SORT(UNIQUE(LEFT(D2:D6, 2))))→ AW, CT, FB, NW

SORT puts the list in alphabetical order before it's joined. UNIQUE and SORT need Microsoft 365 or Excel 2021 or later.

Without TEXTJOIN, build the list in a helper column, one row at a time. Type =B2 in F2, then =F2&"; "&B3 in F3, and copy F3 down to F6. Each row adds one email to the list above it, so F6 ends up holding all five.

Join only the values that match a condition

TEXTJOIN joins whatever list you give it, so give it a filtered one. Which customers ordered from the NW store? FILTER keeps the emails whose order code starts with NW, and TEXTJOIN joins them:

=TEXTJOIN(", ", TRUE, FILTER(B2:B6, LEFT(D2:D6, 2)="NW"))→ [email protected], [email protected]

The condition can test any column of the same height. These join the orders that used a coupon, and the orders placed in 2026:

=TEXTJOIN(", ", TRUE, FILTER(D2:D6, J2:J6<>""))→ NW-2026-0187, FB-2026-0033
=TEXTJOIN(", ", TRUE, FILTER(D2:D6, YEAR(H2:H6)=2026))→ NW-2026-0187, FB-2026-0033, NW-2026-0451

This works like a lookup that returns every match instead of only the first one, all in one cell. Put the store code in a cell and point the condition at it, and the list changes when you type a different code.

When nothing matches, FILTER returns #CALC!, and TEXTJOIN passes the error on. Give FILTER a third argument to show instead:

=TEXTJOIN(", ", TRUE, FILTER(D2:D6, J2:J6="WELCOME5", "None"))→ None

IFERROR around the whole formula does the same job, but it also hides other errors, such as the #VALUE! FILTER returns when its two ranges have different heights.

FILTER needs Microsoft 365 or Excel 2021 or later. In Excel 2019, use IF instead. It returns the order code for the rows that match and empty text for the rest, and TRUE tells TEXTJOIN to skip the empty text:

=TEXTJOIN(", ", TRUE, IF(J2:J6<>"", D2:D6, ""))→ NW-2026-0187, FB-2026-0033

In Excel 2019, confirm it with Ctrl+Shift+Enter instead of Enter. When nothing matches, the IF version returns empty text rather than an error.

Clean messy text before you join it

& and TEXTJOIN keep every character, spaces included. Join the messy names to their order codes and the extra spaces come along. Here each space is shown as a dot:

FormulaResult
=A4&" ("&D4&")"OLIVIA·chen···(FB-2026-0033)
=A5&" ("&D5&")"noah···patel·(NW-2026-0451)

A4's two spaces at the end, plus the one in " (", leave three spaces before the bracket. The fix is to clean each name before you join it. TRIM removes the extra spaces, and PROPER fixes the capitals:

=PROPER(TRIM(A4))&" ("&D4&")"→ Olivia Chen (FB-2026-0033)
=PROPER(TRIM(A5))&" <"&B5&">"→ Noah Patel <[email protected]>

The second one builds a name and address in the format email programs use. TEXTJOIN takes a cleaned range the same way, so one formula cleans and joins three names:

=TEXTJOIN(", ", TRUE, PROPER(TRIM(A3:A5)))→ Liam O'Brien, Olivia Chen, Noah Patel

In Excel 2019, confirm that one with Ctrl+Shift+Enter.

Your turn. The sheet below is live and uses the same customer export. Before the name in A2 can go into a label or a list, it needs cleaning: it has extra spaces at the start, in the middle and at the end, and messy capitals. Clean it in one formula, then press Enter.

Try it yourself

A live spreadsheet. Type a formula and press Enter to check it.

Exercise 1 of 11TRIMPROPER

Clean the name in A2: remove the extra spaces and capitalize it properly.

Write your formula in the green cell, G2.

customer-export.xlsx
fx
1Full nameEmailPhoneOrder code
2 emma JOHNSON [email protected](555) 201-4433NW-2026-0187Clean name
3liam o'brien[email protected]555.388.1902CT-2025-0942
4OLIVIA chen [email protected]555-647-2210FB-2026-0033
5noah patel[email protected](555) 903 7751NW-2026-0451
6Sofia Martinez[email protected]555 412 0098AW-2024-1120
7
8
9
10

Click a cell to add it to your formula, drag to select a range, or click a column letter for the whole column.

Once a name is clean, joining it is the easy part. The TRIM guide covers the spaces TRIM can't remove, and to go the other way and take a full name apart, see how to split first and last names.

Add a line break with CHAR(10)

CHAR(10) is the line break character, the same one Alt+Enter types inside a cell. Join it like any other piece. This puts a customer's name, email and phone number on three lines in one cell:

=PROPER(TRIM(A5))&CHAR(10)&B5&CHAR(10)&C5

The cell shows Noah Patel on the first line, [email protected] on the second and (555) 903 7751 on the third. For the lines to show, turn on Wrap Text for the cell, on the Home tab. Without it, Excel shows everything on one line. If the row doesn't grow to fit, double-click the border below its row number.

CHAR(10) also works as TEXTJOIN's delimiter. This puts each email on a line of its own, all in one cell:

=TEXTJOIN(CHAR(10), TRUE, B2:B6)

CHAR(10) works in Excel for Mac too. Older tips sometimes say to use CHAR(13) on a Mac, but current versions of Excel for Mac use CHAR(10), the same as Windows. To turn the line breaks back into commas later, swap them with SUBSTITUTE. If the list is in F2, =SUBSTITUTE(F2, CHAR(10), ", ") does it. The TRIM guide shows how to remove line breaks with CLEAN.

Keep dates and numbers formatted with TEXT

& joins the value stored in a cell, not what the cell shows. A date is stored as a serial number, a count of days, and a format only changes how it looks. The days between dates guide explains how that works. So when you join a date or a price, the formatting disappears:

=D2&" was ordered on "&H2→ NW-2026-0187 was ordered on 46090
="Total: "&I2→ Total: 1250

H2 shows Mar 9, 2026, but the number behind it is 46090. I2 shows $1,250.00, but it holds 1250. TEXT fixes both. It turns a value into text in the format you give it:

=TEXT(value, format_text)

Wrap the date or number in TEXT before you join it:

=D2&" was ordered on "&TEXT(H2, "mmm d, yyyy")→ NW-2026-0187 was ordered on Mar 9, 2026
="Total: "&TEXT(I2, "$#,##0.00")→ Total: $1,250.00

The format code goes in quotes and uses the same codes as custom number formats. Here are some useful ones, with the date in H2 and the total in I4:

FormulaResult
=TEXT(H2, "mmm d, yyyy")Mar 9, 2026
=TEXT(H2, "mmmm d, yyyy")March 9, 2026
=TEXT(H2, "dddd, mmmm d")Monday, March 9
=TEXT(H2, "mm/dd/yyyy")03/09/2026
=TEXT(H2, "yyyy-mm-dd")2026-03-09
=TEXT(I4, "$#,##0.00")$4,310.75
=TEXT(I4, "#,##0")4,311
=TEXT(0.125, "0.0%")12.5%

TEXT rounds to the format, so "#,##0" turns 4,310.75 into 4,311. That rounding is also the fix for long decimals. Split the total in I4 into three payments, and & shows every digit Excel has:

="Each of 3 payments: "&I4/3→ Each of 3 payments: 1436.91666666667
="Each of 3 payments: "&TEXT(I4/3, "$#,##0.00")→ Each of 3 payments: $1,436.92

The same goes for today's date. ="Updated "&TEXT(TODAY(), "mmm d, yyyy") returned Updated Nov 20, 2026 on the day this guide was published, and it changes every day.

TEXT returns text, so use it only in the joined result. Keep the original dates and numbers in their own cells for any math.

Add quotation marks to joined text

Double quotes mark where typed text starts and ends, so a quote inside the text needs a trick. Type it twice:

="Order """&D5&""" is on its way"→ Order "NW-2026-0451" is on its way

Inside quotes, "" stands for one quotation mark. So "Order """ is the word Order, a space and a quote, and """ is on its way" is a quote followed by the rest of the sentence. A quote on its own is four quotation marks in a row, """".

If that's hard to read, use CHAR(34), the quotation mark character:

="Order "&CHAR(34)&D5&CHAR(34)&" is on its way"→ Order "NW-2026-0451" is on its way

Apostrophes and single quotes need nothing special. That's why liam o'brien in A3 joins like any other text.

Combine cells without a formula: Flash Fill

Flash Fill, Ctrl+E, fills a column by copying a pattern you type:

  1. In the first empty column next to the data, type row 2 combined the way you want it, such as NW-2026-0187: [email protected].
  2. Press Enter, then press Ctrl+E, or click Data > Flash Fill.

Excel fills the rows below with the same pattern, joining the order code and the email from each row. Flash Fill guesses the pattern from your example, and it doesn't tell you when it guesses wrong. Check every row, especially the messy names. Its results are values, not formulas, so they don't change when the data does. When the data changes often, use a formula instead.

Turn the results into values

A formula that joins cells depends on them. Delete the original columns and the results turn into #REF!. To keep the joined text on its own, replace the formulas with their results:

  1. Select the cells with the formulas and copy them with Ctrl+C.
  2. Right-click the first cell and choose Paste Special > Values, or press Ctrl+Alt+V, then V, then Enter.

The cells now hold the joined text, and you can delete or change the original columns. For a formula that spills, such as =D2:D6&" "&C2:C6, select the whole spilled range before you copy. The TRIM guide has the same steps for replacing the original data.

Common mistakes when concatenating

ProblemWhat's going onFix
#NAME?, or Excel says there's a problem with the formulaTyped text without quotes, or a missing &Put typed text in " ", and an & between every pair of pieces
The words run together& adds nothing between the piecesJoin a space, " ", between them
Extra spaces inside the resultThe cells have extra spacesTRIM each piece before joining it
46090 instead of a date& joins the serial number behind the dateTEXT(H2, "mmm d, yyyy")
1250 instead of $1,250.00, or long decimals& ignores number formatsTEXT(I2, "$#,##0.00")
=CONCATENATE(D2:D6) doesn't join the codesCONCATENATE doesn't accept rangesCONCAT, or TEXTJOIN for a separator
#NAME? from CONCAT or TEXTJOINExcel 2016 without a subscription, or older, doesn't have themUse & or CONCATENATE
Extra commas, as in SPRING10, , FREESHIPEmpty cells still get a separatorTEXTJOIN with TRUE
#CALC! from TEXTJOIN with FILTERNothing matchedFILTER's third argument, such as "None"
#VALUE! from TEXTJOIN or CONCATThe result is longer than 32,767 charactersJoin fewer cells per formula
The line breaks don't showWrap Text is offHome > Wrap Text
The formula shows as text instead of a resultThe cell was formatted as Text before you typed itFormat the cell as General and enter the formula again
#REF! after deleting the original columnsThe formulas still point at themPaste Special > Values first

Frequently asked questions about concatenating in Excel

How do I combine first and last names?

Join them with a space in between. Say F2 holds Grace and G2 holds Kim:

=F2&" "&G2→ Grace Kim
=G2&", "&F2→ Kim, Grace

If there's a middle name column that's sometimes empty, use TEXTJOIN with TRUE, so a missing middle name doesn't leave two spaces. The split names guide shows that case, and how to take full names apart in the first place.

How do I merge two cells without losing data?

Not with Merge & Center. It keeps only the value in the upper-left cell and deletes the rest, after a warning. Combine the text with a formula in an empty column instead, such as =D2&" "&B2, and paste it as values. If you only want the text centered across several columns, Center Across Selection, under Format Cells > Alignment, does that without merging anything.

How do I add text to the start or end of every cell?

Join the text to the cell and copy the formula down. This adds a country code to the phone number in C4:

="+1 "&C4→ +1 555-647-2210

Joining is also how you build links. =HYPERLINK("mailto:"&B4, PROPER(TRIM(A4))) shows Olivia Chen as a link that opens a new email to [email protected].

Is there a limit to how much text I can join?

Yes. A cell holds up to 32,767 characters. If the result of CONCAT or TEXTJOIN would be longer, they return #VALUE!. That's only a problem for very long lists. Check a result's length with LEN, and split the list across several cells if it gets close.

How do I split combined text back into separate cells?

In Microsoft 365, Excel 2024 and Excel for the web, TEXTSPLIT splits a text at a delimiter. With the list of emails from the helper column in F6, =TEXTSPLIT(F6, "; ") spills the five addresses back into separate cells. For one part at a time, or in older versions, see the LEFT, RIGHT and MID guide. The split names guide covers Text to Columns and Flash Fill too.

Which versions of Excel have CONCAT and TEXTJOIN?

The & operator and CONCATENATE work in every version of Excel, on Windows and Mac, and so do TEXT and CHAR. CONCAT and TEXTJOIN need Excel 2019 or later, Microsoft 365 or Excel for the web, on Windows or Mac. Excel 2016 has them only with a Microsoft 365 subscription. Typed into Excel 2016 without one, or into an older version, they return #NAME?, and a file that uses them shows the formulas with an _xlfn. prefix in front. Use & there instead.

Joining whole ranges with &, as in =D2:D6&" "&C2:C6, needs Microsoft 365 or Excel 2021 or later. So does giving TEXTJOIN a calculated range, such as TRIM(J2:J6) or an IF test, without Ctrl+Shift+Enter. In Excel 2019, confirm those TEXTJOIN formulas with Ctrl+Shift+Enter. FILTER, UNIQUE and SORT need Microsoft 365 or Excel 2021 or later, and Flash Fill needs Excel 2013 or later.

In Google Sheets, & works the same way, and TEXTJOIN has the same arguments. CONCATENATE accepts ranges there, and CONCAT joins exactly two values. For Microsoft's own examples, see the CONCAT function, TEXTJOIN function, CONCATENATE function and TEXT function pages.

For more practice, the text topic has the free clean-name and left-code exercises on the same customer export, plus Premium exercises on a label built from a code and a clean name and joining a list with TEXTJOIN.

Key takeaways

  • The & operator joins text in every version of Excel. Put typed text, spaces and commas in double quotes, as in =D3&" "&B3, and an & between every pair of pieces.
  • =TEXTJOIN(delimiter, ignore_empty, text1, ...) joins a range with the same separator between the items, and TRUE skips empty cells. CONCAT joins a range with no separator, and CONCATENATE is the older function that doesn't accept ranges.
  • & keeps every character, so TRIM and PROPER messy pieces before joining them. Wrap dates and numbers in TEXT, such as TEXT(H2, "mmm d, yyyy"), or they come out as plain numbers.
  • Use CHAR(10) with Wrap Text for line breaks, TEXTJOIN with FILTER to join only matching values, and Paste Special > Values before deleting the original columns.

Practice

Keep going with CONCAT and CONCATENATE exercises

Reading gets you started. Solving a few of these is what makes it stick.

  1. 1Build a label PremiumFor row 5, build a label like AW-2024-1120 - Sofia Martinez: the order code, a space, a dash, a space, then the clean name.→
  2. 2Join a list PremiumJoin all five order codes in D2:D6 into one cell, separated by a comma and a space.→
  3. 3Clean up a nameFreeClean the name in A2: remove the extra spaces and capitalize it properly.→
  4. 4Store codeFreeGet the 2-letter store code from the start of the order code in D3.→
All text exercises →
Brian Millot

About the author

Brian Millot

Brian Millot is an indie hacker based in France who builds small, focused web products. He built and runs Excel Formula Practice, from the in-browser spreadsheet that checks your formulas to the exercise library, and he writes the formula guides.

Related guides

Practice makes formulas

Stop reading. Start typing formulas.

Every exercise is a real spreadsheet with instant feedback. The first two in every topic are free, no sign-up needed.