3 years ago

Concatenate function with space in Excel | Excel Practice Case #11
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

The word CONCATENATE means to join or combine. The CONCATENATE function in Excel is used to combine the text from different cells into one cell.

How to combine data using the CONCATENATE function (Best Method)
1 - Choose the cell in which the combined data should be placed.
2 - Enter the type =CONCAT(.
3 - The first step is to select the cell you would like to combine.
4- If you want to add spaces, commas, or other text, use quotation marks to distinguish the cells you are combining.
5 - Enter the formula after closing it with a parenthesis.
6 - Formula Example =CONCATENATE(A2, "Excel").

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
╔═╦╗╔╦╗╔═╦═╦╦╦╦╗╔═╗
║╚╣║║║╚╣╚╣╔╣╔╣║╚╣═╣
╠╗║╚╝║║╠╗║╚╣║║║║║═╣
╚═╩══╩═╩═╩═╩╝╚╩═╩═╝
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

🙋🏼‍♂️ PLEASE SUBSCRIBE
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
✅ SUBSCRIBE HERE 👉 https://bit.ly/3cQUVZZ
🆓 DOWNLOAD the Exercise file and solution for this video here 👉 https://bit.ly/3pJVurI

SUPPORT THE CHANNEL
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
👉Teespring Merch&Books 👉 https://bit.ly/3S1fa7n

Social Media / Contact us
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
🤳Dexcelo on TikTok 👉 https://bit.ly/3JgslNU
📥 Business Inquiries 👉 [email protected]

📊 In this course you will learn how to:
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
- Joining two cells in one cell
- Use the concatenate formula to join the text strings and add space in between
- Use the "&" instead of concatenate
- Paste full names as values shortcut CTRL + ALT + V + V

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
✏️ Course developed by Dexcelo.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
0:00:00 - 0:02:33 Intro & Objectives
0:02:33 - 0:05:58 Use CONCATENATE with space
0:05:58 - 0:09:07 Use Ampersand instead of CONCATENATE
0:09:07 - 0:11:00 Paste value
0:11:00 - 0:13:40 Objectives Summary

🔗 Useful Links
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⚈ Microsoft Excel Help Center https://bit.ly/3Q99vu8
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Thank you for your support 🙏🙏🙏 !!!
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Tags
#concatenatefunctionwithspace #excel #اكسل #concatenate

Loading comments...