How to Combine Cells in Excel (Using formulas) | Combine Columns in Excel
ฝัง
- เผยแพร่เมื่อ 7 ก.ค. 2024
- In this video, I will show you how to use simple formulas to combines cells and combine columns in Excel.
The following three examples are covered in this video:
1. Combine cells in Excel (with and without separators, such as comma or space)
2. Combine cells with line breaks in the result
3. Combine cells with text and numbers
Free Excel Course - trumpexcel.com/learn-excel/
Paid Online Training - trumpexcel.com/excel-training/
Best Excel Books: trumpexcel.com/best-excel-books/
⚙️ Gear I Recommend:
Camera - amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - amzn.to/2uzhVHd
Wireless Mic: amzn.to/3blQ8uk
Lighting - amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: th-cam.com/users/trumpexc...
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
![ตีสิบเดย์ [FULL] | ครอบครัวสะท้านทุ่ง "นางบี & อ้ายสติ๊ก"](http://i.ytimg.com/vi/A1rhYcxxNtA/mqdefault.jpg)
If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what topics you want me to cover in future videos.
Hi
Is is possible to have conditional text join?
Very nice
Awesome video
Very useful for me...Thanks a lot
you are the best guru for those who have not money for pay
Thanks for the kind words Mahesh... glad you're finding the videos useful!
The first one I knew.. I use concatenate more than the regular =D3 simply to tell me instantly it's a join function as I have a lot of calculations. The second one is magical. I knew how to do it in VBA but not in excel. I need to go do several rewrites with char(10)! The third one...mind blowing. Seriously not going to say how I did a work around on getting dates to copy over with text... it was ugly but worked. I have a bunch of cleaning up to do when I get back. Excellent build-up. LOVE your videos. I learn things I didn't even know to ask about!
I didn't know the third one. I always felt trouble in retaining the format of the cells after combining them. Thank you for saving my time. :)
Thanks sumit
You gives a simple solution to many common problems. Very useful video 👍👌👏
Very helpful...thanks!
Thank you man!
Superb, thank you
Thanks so much!
Very imp information
Nice & LEARNING...THANKS
Thank you for this great video!
Glad you liked it Vanesa!
Awesome video sir and very helpful for all Excel users.
Thank You Sir
that is sooooooooooooooooooooooo helpful. Massive thank you for sharing this knowledge.
Glad you found it helpful!
Thank you very much
That is helped me alot
Again a great video. Awesome explanation.
Glad you liked it Subhodeep!
superb video, nice explanation 👌
Thanks for commenting Tushar.. Glad you liked the video!
Yes dear bro I subscribed !!! Great infermation thanks a lot!!!!
Bravo Trum excel ...Pl make more Videous ,it was very helpful
this is a wonderful video
Nice
Really many thanks for your always help. it will be more benefits if you allow us to download your excel tutorial. waiting for your reply
Hi Sumit.. great video.. some very useful tips there. Thanks for sharing. Thumbs up for Trump Excel!!
Awesome Tutorial! Your videos have helped me greatly. Thank you! I wonder if there is a general code to keep ANY formatting that was in the cell that is being concatenated. (ie: If I have a questionnaire with questions and data that contain a mix of dates, numbers and written answers.) After the grouping, I would want to keep Date formats, number formats and general text formats too. Without having to go to each formula and adjust the text(xx,______ section for each different one. Does such a formula or function exist?
Really good!
Thanks for commenting Hemant... Glad you liked it!
Superb bro
This is super
Thank you.।।
बहुत बढ़िया समझाया आपने कृपया बताएं कौन सा video editor and recorder use krte hai
Camtasia for screen recording
@@trumpexcel बहुत-बहुत धन्यवाद सुमित जी आपका आपके महत्वपूर्ण समय और जवाब के लिए
I like it 👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻
opened your e mail... clicked on the link and subscribed and gave you a big thumbs up!
Sir do you have any video about - How do I concatenate cell values until it finds a blank cell
.? The answer should display in the blank cell. If so then please send me the link.
Heyy man how do i combine randomly separated cells with the same pivot/header names (gform problems) into one column
I have one table of 12 columns & second table of 8 column. How to fit that two tables in one sheet, one after another?
Sooooper
After creating the merged data, how do you move that data to a new sheet? Currently, only the formula is perserved.
THANKS FOR THIS TUTORIAL. I'm merging a 12-month data from Jan to Dec on respective sheets in same workbook. Each sheet is made up of three columns - viz; a/c code, name and amount. The challenge is that some months have names that are not in the other sheet or months , resulting in more rows in some sheets than others. The order of names in month 1 sheet differ from other sheets hence, it's been difficult to have a uniform name and account code columns to allow the amounts to be added for every row across all the sheets. this is making me spent more time cleaning the data for merging up to a master sheet for consolidated values in the amount field for all the names that have recurred with multiple amounts across the months. Pls can you help? CLEMENT.
Can you please help if i have a data include some dates in the same column are in dd/mm/yyyy and some data are in mm/dd/yyyy format i just want to sort in the same column at once.
Hai
How can block(lock) excel workbook if change the excel file server location(file path) or copy to other system thro macro.
Sir , if the 2 cells have different text colour and we want the final answer to have that same colours after joining , so how to do that without using VBA .
plz provide us excel sheet link for practice... thanks!!!
Please how can I get a copy of this video
SIR, i would like to ask you this concat formula is not working in my Excel 13. does it not work in Excel 13 ?
You can use CONCATENATE function instead
Hi Sumit..what is char 10? I didn't understand...
I have situation where I need to display dates from 21st of previous month to 20th of current month. Basically, I want to have 3 rows. First row should show a merge cells such they will show like March and April. The next row would be dates in series from 21 to 20 formatted with "d". The third would be day represented by LEFT(TEXT(cellreference,"ddd"),1). My question is, is there a way to create 1st row by formula. Please understand the starting will be dynamically changing like I might input 21-Feb or 21-Mar or 21-Apr etc. Let me know if you have any solution to this scenario. Thanks in advance.
How to join 2 cells without losing the format, the other one cells is Bold, while the other one is italic? Is there a way not to lose the formating?
sir I have confusion that someone say that in Excel job has no scope and progress .Is it true sir. Can I not progress with Excel skill with advance knowledge.please sir clear my confusion and reply me .
coolll
This was great, until my true purpose collided with the reality. My goal was to combine several columns into one and then delete the original columns. When I deleted the original columns my nice new column had the "ref" error. So, not as quick and easy as I had hoped.
This has an easy fix. After you have applied the formula, just replace the formula with values (super easy to do). Here is a tutorial on how to do this - th-cam.com/video/c2uFZAU1Ctc/w-d-xo.html