how to add a space between text in excel

How to Add a Space Between Text in Excel

By Thomas Brown
AD

Ever found yourself wanting to add a space between text in Excel but couldn't figure out how? You're not alone. Excel, a powerful tool for data management, can be tricky to navigate at times. But don't worry, adding a space between text in Excel is actually quite simple once you know how.

In this guide, we'll walk you through step-by-step processes to add a space between text in Excel, both manually and using a formula. Let's dive right in!

Manual Method to Add a Space Between Text in Excel

The manual method is straightforward and best suited for adding spaces between text in a small range of cells.

AD
How to insert space between number and text in cells in Excel?
How to insert space between number and text in cells in Excel?
How to Add Space Between Text in a Cell in Excel (4 Easy Ways) - ExcelDemy
How to Add Space Between Text in a Cell in Excel (4 Easy Ways) - ExcelDemy
Comment ajouter de l'espace entre le texte et les bordures de cellule dans Excel
Comment ajouter de l'espace entre le texte et les bordures de cellule dans Excel

Here's how you can do it:

Using the Insert Function

1. Select the cell where you want to add space.

How to Combine Text Cells in Excel with the Concatenate Formula
How to Combine Text Cells in Excel with the Concatenate Formula
Excel tricks
Excel tricks

2. Click on "Home" and then click on the small arrow next to the "Insert" button in the "Editing" section.

3. Select "Insert"... and " Symbols" from the drop-down menus.

AD

4. In the "_SYMBOLS" dialog box, select "Symbol".

5. In the "Font" box, choose "Arial" (or any font that supports ASCII space characters).

6. Scroll down to find "Character code", and enter "160" for non-breaking space (it doesn't move when you wrap text), or "32" for regular space.

AD

7. Click "Insert", then "Close".

Using the Alt Code Method

1. Select the cell where you want to add a space.

2. Type or select the cell with the content.

AD

3. In the second cell, press Alt + 0160 (for a non-breaking space), or Alt + 032 (for a regular space).

4. Press Enter.

Using Formulas to Add a Space Between Text in Excel

For larger data ranges, using formulas can save time. Here's how you can do it:

CONCATENATE Function

1. Assume 'A1' contains the text you want to add a space to.

2. In 'B1', enter the formula: "=CONCATENATE(A1, ” ”)".

3. Press Enter. The result with a space is shown in cell 'B1'.

TEXTJOIN Function

The TEXTJOIN function is more efficient and easier to use than the CONCATENATE function. Here's how:

1. Assume 'A1:A5' contains the text you want to add a space to.

2. In any other cell, enter the formula: "=TEXTJOIN(" " , TRUE, A1:A5)".

3. Press Enter. The result with spaces is shown in that cell.

And there you have it – several ways to add a space between text in Excel! Practice these methods and you'll soon master them. Happy spacing!

AD