• Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

Adding Space (Single and Multiple)

0 Comments

When you need to combine two values in a single cell, it is often necessary to insert a space between those values. Sometimes, you may even need to insert multiple spaces. This tutorial will guide you on how to write a formula to add a space or multiple spaces in Excel.

Adding a Single Space:

  1. Start by entering an equals sign (=) in a cell.
  2. Refer to the cell containing the first value and type an ampersand (&).
  3. Type (” “) to indicate the space you want to add.
  4. Next, refer to the cell containing the second value and type an ampersand (&).
  5. Finally, press Enter to get the result.Single 1

Once you press Enter, you will see both values combined in a single cell with a space between them.Single 2

Example Formula: =A1&” “&B1

Adding Multiple Spaces:

If you want to add more than one space between two values, you can use the REPT function.

In this formula, instead of using a single space, we utilize the REPT function. Within the REPT function, we specify the space and the desired number of repetitions.Single 3

Example Formula: =A1&REPT(” “,20)&B1Single 4

Adding Multiple Spaces for Multiple Values:

If you have multiple values and wish to add a space between each of them while combining, you can use the TEXTJOIN function.Single 5

Within the TEXTJOIN function, you need to specify the delimiter (which, in this case, is a space) to be inserted between each value. Additionally, include TRUE to ignore blank cells, and provide the range containing the values.

Example Formula: =TEXTJOIN(” “,TRUE,A1:A5)

Rate this post
40
266 Views
3 Methods to Copy a Sheet in Microsoft ExcelPrev3 Methods to Copy a Sheet in Microsoft ExcelMay 18, 2023
Find Beautiful Free PowerPoint Icons to Make Your Slides More DynamicMay 18, 2023Find Beautiful Free PowerPoint Icons to Make Your Slides More DynamicNext

Leave a Reply Cancel reply

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
Top rated products
  • Windows Server 2022 Remote Desktop Services User Connections (50) Cal Key Global Windows Server 2022 Remote Desktop Services User Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $22.00
  • AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 2 Years AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 2 Years
    Rated 5.00 out of 5
    $47.00
  • Avast Premium Security 2021 10 Devices 1 Year Global Avast Premium Security 2021 10 Devices 1 Year Global
    Rated 5.00 out of 5
    $28.00
  • Avast Ultimate Suite 2021 3 Years 10 Devices Global Avast Ultimate Suite 2021 3 Years 10 Devices Global
    Rated 5.00 out of 5
    $90.00
  • Windows Server 2022 Remote Desktop Services Device Connections (50) Cal Key Global Windows Server 2022 Remote Desktop Services Device Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $22.00
Products
  • Microsoft Visio Professional 2016 Key 1PC Microsoft Visio Professional 2016 Key 1PC $9.00
  • Windows Server 2022 Remote Desktop Services User Connections (50) Cal Key Global Windows Server 2022 Remote Desktop Services User Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $22.00
  • AVG Internet Security 2021 10 Devices 1 Year Global AVG Internet Security 2021 10 Devices 1 Year Global
    Rated 5.00 out of 5
    $30.00
  • Microsoft Project Standard 2019 - 1 PC Microsoft Project Standard 2019 - 1 PC $12.00
  • Office 2024 Home And Business For Mac/Pc Bind Office 2024 Home And Business For Mac/Pc Bind $99.00
  • Windows Server 2022 Standard Key Global Windows Server 2022 Standard Key Global
    Rated 4.10 out of 5
    $7.00
  • Windows Server 2019 Standard Key Global Windows Server 2019 Standard Key Global
    Rated 4.68 out of 5
    $7.00
  • Windows Server 2016 Datacenter Key Global Windows Server 2016 Datacenter Key Global
    Rated 4.74 out of 5
    $10.00
  • Windows Server 2025 Standard Windows Server 2025 Standard $30.00
  • Trend Micro Internet Security 3 Devices 1 Year Key GLOBAL Trend Micro Internet Security 3 Devices 1 Year Key GLOBAL
    Rated 5.00 out of 5
    $17.00
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.