How to Join Text in Microsoft Excel?

1 minute, 27 seconds Read


In the previous post, we saw “How to Use Sum | Autosum | Max | Min | Average in Excel?“, now we will see how to join or combine text in excel.

How to Combine Text in Excel?

There are many times in Excel when you want to combine texts from different cells. For example, you want to combine First Name and Last Name into Full Name.

First NameLast NameFull Name
JethalalTawdeJethalal Tawde
BatliwalaThakkar 
TangewalaKanate 

In excel you can combine data from multiple cells into a single cell via:

1. Ampersand Symbol (&)

2. CONCATENATE Function


Using Ampersand Symbol (&)

Advertisements

Using the same example

Type = where you want to combine text select the first cell and type ampersand symbol & and used quotation marks with a space enclosed. Select the next cell you want to combine and press enter.

Like this:

Combine text in Excel

Let’s see…..

Combine text in Excel

Using the CONCATENATE Function

With the help of the same example, we will see how to join text using the CONCATENATE function.

Select the cell where you want to join text then type =CONCATENATE( after that select the first cell. Use commas to separate the cells you are combining and use quotation marks to add spaces, commas, or other text.

Close the formula with a parenthesis and press Enter.

Like this:

Let’s See…..

Combine text in Excel

In this way you can Combine text from two or more cells into one cell. In the next post we will see how to join text and numbers.

You can join text and number in the same way as above we did but it needs to be formatted in the correct way so that it is easily understandable to anyone so let’s see it in the next post.


For Latest Updates & Learning Join Our YouTube Channel: Join Now

author

EduTaxTuber Team

We are here to help for every updates related to everything...👍📙👍📗

Similar Posts

Leave a Reply

Realme 10 Pro and 10 Pro+ Launched RBI Monetary Policy Highlights England vs Senegal: FIFA World Cup 2022 No Curfew in Mumbai: Section 144 Imposed to ensure Peace Elon Musk suspends Kanye West Twitter Account for inciting violence