WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to create space in a formula in WPS Office Excel

January 21, 2022
3.4K Views

Are you ready to master how to create space in a formulain excel? After learning this WPS free course, you will be advanced from a beginner in WPS Spreadsheet. 

WPS Spreadsheet iscompatible with Microsoft Office Excel. As the world's leading developer of office software solutions, WPS Office provides free applications for individuals and businesses to improve productivity.

How can we insert space in a formula to make it displayed in the result? When do we need space in the formula? In other words, when do we need to add space?

Suppose you are an HR of a company and have the first name and last name and need to get the full name. Clever as you, you might already know how the CONCATENATE function works, which can combine the text of two separated cells. But how to create space between them?

If you are not familiar with the CONCATENATE function, don't worry, let's figure it out together.

1. Place your cursor in C2, enter the following formula

=CONCATENATE(A2,B2)

Here is why we write the formula:

Syntax:CONCATENATE(text1, [text2], ...)

Argument:Text1means the first argument to join, text2 and more are the additional texts or numbers to combine. We want to join text from A2 (First Name) with the text from B2 (Last Name) and pull them together in C2 (Full Name).

2. By doing so, we may find the result is still not what we see in our daily life, as spaces are missing. To solve this, we need to adjust the formula we wrote. Enter the following formula=CONCATENATE(A2, , B2)

Here, we have added a space between the first and last names. Don't forget to add the quotes. Then drag it all the way down.

3. Here, we have inserted a space in the CONCATENATE function.

WPS Spreadsheet is similar to Microsoft Office and is available for Windows, PC, Mac, Linux, Android, and iOS devices.

To explore more about WPS Spreadsheet :

We have learned how to combine two columns together, click here to see how to split columns in WPS Academy's video tutorials.

Here, we have learned a easy yet useful way to add space to your formula. Did you get it?

Excel is the most powerful tool to manage and analyze various types of Data. This free WPS Spreadsheet tutorial for beginners covers in-depth lessons for Excel learning and how to use various Excel formulas, tables and charts for managing small to large scale business process.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.