• 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
33
261 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
  • Kaspersky Small Office Security 15 PCs + 15 Mobiles + 2 Servers 1 Year Kaspersky Small Office Security 15 PCs + 15 Mobiles + 2 Servers 1 Year
    Rated 5.00 out of 5
    $201.00
  • Buy Windows 11 Professional MS Products CD Key Buy Windows 11 Professional MS Products CD Key
    Rated 5.00 out of 5
    $6.00
  • AVG Internet Security 2021 1 Device 1 Year Global AVG Internet Security 2021 1 Device 1 Year Global
    Rated 5.00 out of 5
    $11.00
  • Buy Office 2021 Professional Plus Key Global For 5 PC Buy Office 2021 Professional Plus Key Global For 5 PC
    Rated 5.00 out of 5
    $68.00
  • Avast SecureLine VPN 2021 2 Years 5 Devices Global Avast SecureLine VPN 2021 2 Years 5 Devices Global
    Rated 5.00 out of 5
    $47.00
Products
  • 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
  • Windows 10 Pro Key Global Windows 10 Pro Key Global
    Rated 4.74 out of 5
    $6.00
  • microsoft office home and business 2019 pcmac key Microsoft Office Home And Business 2019 (MAC) key bind to your Microsoft account
    Rated 4.95 out of 5
    $30.00
  • Windows Server 2008 R2 Standard Windows Server 2008 R2 Standard $10.00
  • Microsoft Project Standard 2019 - 1 PC Microsoft Project Standard 2019 - 1 PC $12.00
  • Microsoft Visual Studio Enterprise 2022 For 1 PC Microsoft Visual Studio Enterprise 2022 For 1 PC $19.00
  • Microsoft Visual Studio 2022 Professional Key Microsoft Visual Studio 2022 Professional Key $19.00
  • SQL Server 2014 Standard SQL Server 2014 Standard $20.00
  • Windows 10 Education Key Global Windows 10 Education Key Global
    Rated 4.84 out of 5
    $9.00
  • Avast Premium Security 2021 10 Devices 2 Years Global Avast Premium Security 2021 10 Devices 2 Years Global
    Rated 5.00 out of 5
    $41.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.