Easily Combine Text & Numbers into ONE Cell in Excel | NO CONCATENATE
Vložit
- čas přidán 2. 06. 2024
- Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
In this video I'll show you how you can combine data (text and numbers) from multiple cells into one cell in Microsoft Excel. You'll learn how to use the TEXT function in Excel to even apply number formatting to the combined cell. I'll show you different approaches without using the Concatenate Function. We'll do it much easier.
⬇️ Download the workbook here: pages.xelplus.com/combine-dat...
I'll also give you a bonus tip on how you can have a text and number combination in a cell and still use formulas on this cell: the Excel trick we'll use here is with Excel custom number formatting.
00:00 Combine Text & Numbers From 2 or More Cells Into 1 Cell
00:30 How to Combine Text and Numbers
02:53 Combine Text & Numbers WITH Formatting
05:00 Bonus: Add Text to Numbers in Excel
07:07 Wrap Up
🔍 What You'll Learn:
- How to dynamically combine data from multiple cells in Excel.
- Techniques to include text in calculations without losing number formats.
- Using the TEXT function for precise number formatting in combined data.
👩💼 Perfect for:
- Excel users keen on enhancing their data presentation.
- Anyone looking to streamline their spreadsheet tasks.
- Excel enthusiasts eager to learn advanced data manipulation tricks.
📌 Key Highlights:
- Combine text and numbers while keeping data dynamic.
- Make Excel recognize text within numbers for formula calculations.
- Apply number formatting within combined text and number cells.
🎬 Learn more about custom number formatting: • Why you SHOULD be USIN...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel
Grab the file I used in the video from here 👉 pages.xelplus.com/combine-data-file
Your videos are awesome. I'm a data analyst and I've been using Excel for 20 years. I always learn something new with your videos!
Great to hear!
If its Thursday, it must be Leila ... my usual routine ... hot coffee while watching Leila's latest presentation.
Interesting approach ... not sure I have an immediate need ... but always appreciate another "tool" in the shop (so to speak).
Whenever I think I know how to do something, you teach me different, more practical and more interesting ways of doing it! Thank you very much for all the effort you put into these videos.
Great video as always Leila.
I often use this Custom Formatting in my spreadsheets - "as of " dd/mm/yyyy
Then just use the keyboard shortcut Ctrl + ;
or a date calculation
to end up with a date that is still a date in the cell, but prefixed with "as of " (or "last updated on ", or "Due by ", etc)
Simply amazing!! I have been trying to do this very thing for a day or two and just like that, you solved my dilemma. Thank you.
Craziest thing just happened. I was working in a spreadsheet last night someone else setup, and there was text added onto a result that did not exist in the equation. It was a big WTF moment. Had no idea how to attack it. Did not search for this video, just happened to click on it during random you tubing and here I come to your explanation at the end! GET OUT OF MY HEAD! 😀 Mind blown. Awesome job!
Exactly the problem I need to address this morning. Thanks! I've added your channel as required assignments for my staff.
Я не понимаю по английский и не знаю excel но мне очень нравиться на вас смотреть и вас слушать...
Большое спасибо!
We are soo lucky to have Leila Gharani here in CZcams. ❤️
Great tips, Leila! I just loved them! Thanks for sharing!
Wow! The bonus tip was amazing. Thanks Leila. You are My Excel guru. Keep it up!
very simple and helpful video. Thank you. this was exactly what i needed.
Glad it was helpful!
Brilliant! Thank you for your clear and concise delivery
That last trick is INGENIOUS! I realized what you were doing a split second before you did it, and I feel silly for never considering that before!
Great formatting and presentation tricks and tips Leila! Thanks for sharing. Thumbs up!!
Your videos are amazing. I wish I found your videos sooner. Most people have Excel on their desktops and have no idea how powerful Excel is. It is mostly taken for granted.
you are simply great and helping lot of people, great dude
Very concise, thank you!
Great tutorial as always Leila. My Excel has improved so much from watching your videos. Thanks for sharing
THANKS ;) and Happy new year!
Excellent!! Thanks Leila!!👍🏾
Exactly what I was looking for. Thank you so much!
my go-to channel everytime i need excel tutoring! thanks leila!
I always learn something new. Thanks Leila.
Neat tricks. Mind blowing as always. Thank you Leila.
EXACTLY what I needed!
There are two major revelations in this short tutorial for me!! I have had the occasion to use this several times in the past and can’t wait to use it in the future!
The additional tip is WOW!!
Again!...a golden one! Thanks
Just brilliant!!! 😊 Thank you!!!
Awesome tips! Thank you so much!
Great videos 👍🏾 learning formulas is so helpful and makes life easy!
Nice information , there's always so much to learn in Excel ..never ending
Very useful. Two days ago i was doing and trying something on this topic (didnt get what I wanted to),but after this video, mission complete!!!
Glad it was helpful!
Your bonus tip is awesome....
Thank you so much. It helped a lot. You are amazing! Keep it up!
This is EXACTLY what I was looking for. Thank you so much from a loyal subscriber!!
Thanks leila, i always learn something new from u.
Extremely useful tricks. Thanks, Laila.
Thank you, this is great!
Brilliant, thank you!
Thank you Leila! Truly appreciate your tutorial.
From Singapore 😊
I really didn't know where I can use this but this seems interesting, because you just elaborate the things in a facinating way.
This is awesome!!!
The & is really powerful, i use it in my warehouse job to search for inventory adjustments for product&location. Makes a unique key.
Really love the bonus tip too
This is the type of excel video that I need! Tips that aren't common, and help a TON. Love your videos. Thank you for sharing your tips!
You are so welcome, Stephanie!
You are great inspiration in my life. Thank you so much mam.
So nice of you!
As an Iranian old programmer I am proud of you my daughter Leila khanom
I just subscribed your channel not because of excel . Way your explanation and English both r fabulous.
That's so cool!
The last tip is priceless.
Thank you.
Brilliant, thank you : )
Thanks Leila, very helpful.
Thank you Leila. I will give it a try.
Great tips !
I am searching for this a long time. 👍👍
good info, thanks!
Excellent tutorials... Keep up the good work.
The components of the custom format are:
positive;negative;zero;text
Tip from me... You can format individual text components in the formula bar, i.e. colours, styles etc...
Handy when creating financial accounts and you need to emphasis a change in process.
Fortunately, Microsoft in their wisdom and foresight made every single character an individual addressable object.
Just don't get carried away!
This is great! Thank you for practice tips, shared so clearly!
Glad it was helpful, Julie!
This is great informative education!
Thank you very much for your Informative Tutorial Video....😊
Thank you so much...your vids are always insightful...👍
My pleasure!
Great! Thank you
Awesome, very useful.
You're such an Excel Bad Azz, Leila. Love your videos, thank you!
Great tip!
Like the Lago di Braies photo, beautiful place :)
Again thanks for your support 🙏
Great video. Love this nice tricks
Precise and informative
Congratulations, very good!
Thank you Leila! Every Thursday is enriching us and really appreciate your efforts and consistency in delivering your best! 😊👍
١ضق
That was cool. Thanks
You are super, thanks for your videos)
Good trick... Thanks for sharing
Thanks you Leila. Nice piece of knowledge!
My pleasure!
Pretty cool! Just this week I helped a relative with combining and separating text for a moderately complex project. When I showed her the many ways we can use the & symbol she thought it was like magic. I also showed her how to separate first and last name from a single cell using the functions "left", "mid", and "search." Normally, she would manually separate a couple of hundred cells with names. I wasn't aware that I could create my own custom number format with text so that's nice to know if I ever need it. Thanks!
The "Text to Columns" tool (on the Data tab) is also good for separating things like full names into first, middle, last.
@@JenniferPipinou . Nice! I'll remember that! Thanks!
Wow...... !
Loved it.
Although, i have been using both of these for quit long, but your unique way of teaching........
You are awesome Leila!
Thanks so much 😊
@@LeilaGharani Nothing like a beautiful woman with business sense. Are you taken cuz I see no ring on your finger🤔😁
@@JoeJacksonsBelt shooting the shot lolz
@@JoeJacksonsBelt Married with children :-)
@@ahmedakande6283 😆 just thought I would try
Thank you very big for this.
God Bless You Ma'am.
Superb Simple and genius work with so east tricks.
Thanks
This one is very useful.... Now my boss happy from me.. i do this activity
Thanks LG... Lots of love💕💕💕
Always good when the boss is happy 😁
@@LeilaGharani Thanks for your valuable reply...I am a big fan of your Personality 😘😘😘
Excellent !
Thank you very much indeed!!!
You are the best!
Thanks for the tips.
In the format window @ 4:24 - I always prefer to press cancel to avoid applying unintentional settings.
Always Great Leila
Thanks Leila! The bonus tip was great
My pleasure, Chris!
Nice work Leila!
I knew some of the techniques but a good refresher.
Great to hear!
Thank you miss Leila now I can come to your channel for any excel related doubts
I am crazy about your voice 🥰
And knowledge of course ☺️
I was unaware of the forlula named "TEXT". This solved a complicated problem for me. Thanks a Ton.
Ghank yoy for a very good explanation
THANK YOU!
Thank you!
I like it.
Thanks.
Brilliant!
Oh man.
Ihr Mann ist ein verfluchter Glückspilz.
Very very nice intersting, thank you so much.
Glad you enjoyed it.
I've used this several times. Very good explanation. The key here being that's it's dynamic. If you just wanted a column with this format, you could type in the first one and then use Flash Fill - but it's static at that point.
Ŕ
Éď
it's super thank you