- Finance & Accounting
- Programming & Development
- IT & Software
- Office Productivity
- Education Management
- Business Software
- HR & Recruiting
- Video Resume
- Small Business
- Women Owned Businesses
- Businesses Owned by People of Color
- Health and Wellness
- Sales and Marketing Example
- Video Blitz Submission
- Legal and Law
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.
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
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
=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