How to Use Concatenate in Excel | Use the Excel Concatenate Function

⁣Welcome to our Channel..

Today we are Welcome to Choose..

How to use Concatenate in Excel...

What is the Concatenate Formula and Why do we use it?

We can use it to combine names.

30 values are joined by the concatenate function, which outputs the results as text.

You just want the name' information. If you want to combine the data from the last and first main columns in one cell, doing so by hand would take a lot of time. We can use the concatenate function to automatically combine these data rather than manually doing so to finish the task right away.

Let's begin the instruction of tutorial

● As you can see, I have written the first name and last name in these two columns.

FULL NAME

Now as you can see there is no gapping between so now we will type
=CONCATENATE (A2,““, B2)
If you want to add both the first and the last name type this formula to get a full name with the gap

HYPHEN

If you want to use a Hyphen simply use the formula
= CONCATENATE (A2, “-”, B2)

FULL NAME CAPITAL LETTER

If you want to add your full name in capital letter
You can add this formula
=upper (CONCATENATE(A2,“ “,B2))

FULL NAME LOWER CASES

And the same method goes with the full name with the lower cases
=lower CONCATENATE(A2,“ “, B2))
A2 double code open and double code close comma B2 bracket Close
And here it goes the full name with the gap

SHORTCUTS

=A2 & “ “ & B2 and Start

That is in this video..

I hope you find it is helpful.

Also if you like this video.

Please subscribe to our channel for such informational videos.

#DancingNumbers #MicrosoftExcel #ExcelTutorials #ExcelVideoTutorials

See all Excel tutorial videos here: https://www.youtube.com/playli....st?list=PLtVAMpwp7qC

💠💠Try the Free Trials For QuickBooks Desktop: https://bit.ly/dancingnumbers-desktop 💠💠
💠💠Try the Free Trials For QuickBooks Online: https://bit.ly/dancingnumbers-online 💠💠

You can Connect with us on Social Media:

☛ Facebook: https://bit.ly/33SO5Mk
☛ Twitter: https://bit.ly/3lVfnb8
☛ Instagram: https://bit.ly/3oBuisq