If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos. Here are some other Excel tips videos you may find useful: ✅ How to Delete Blank Rows in Excel - ruclips.net/video/2t6gEKjTqvI/видео.html ✅ How to Remove Leading and Trailing Spaces in Excel - ruclips.net/video/EGien2dwG9M/видео.html Also, I have made all of my Excel courses available for free. You can check these out using the below links: ✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/ ✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course ✅ Free VBA course - bit.ly/excel-vba-course ✅ Free Power Query Course - bit.ly/power-query-course
0:08 Trim extra space 1:19 select blank cells. treat then all the same. 2:39 Convert numbers stored as text into numbers 4:59 Remove duplicates 7:21 Highlight errors 9:24 Change text to lower/UPPER/Proper case 10:54 break up concatenated text (e.g. street address) into separate columns 13:15 Spell check 14:33 Find and Replace 16:59 remove line breaks in text 17:47 Clean (out unwanted characters from) text data
I have taken to learning excel on a full time after my retirement in May 2017. First it started as a hobby and now it has become an obsession since it gives me a lot of happiness. I almost spend 4 to 5 hours going through all the excel videos that come in RUclips and practice each one of them. I can definitely say that the way you teach excel is simply fantastic. All the explanations are extremely crisp. Hats off to your work
There are many excel teachers in the RUclips, but i must say the way you guys teach and summarise the functions are awesome. Well done and keep inspiring guys.
Thanks for sharing,buddy.Learn a lot from your channels in easy and simple ways.Hindi:Kee sai ho?T-Koo.Can/t lai lee kai ho can/t lai nei he?Can/t lai nei he kai ah mei tao mei key lai dar hung.Au bag dai bar kar kar hei.Bo ho ma sai he hei.Tao lee tao lee,Hindi,Hindu art dee hei.Mei,Hindi,Hindo art dee hei?Mei India kam kee hei ,kar kee hei.Au bag dai bar kar kar hei,easy art dee hei.Bo ho ma sai he hei.Bar hei bo ho got me hei?Kam beer jar dar ban lee "B lai"Bar hei bo ho bar lish hei?Chut dar sure lure kee mut.Mei jar lai ha hung,Bo ho tek kee hung.Bar mei link it.Mei ban lee.So kar lee ah.Ug lai hip see dai mei link it.So kar lee ah.Doom ah char in shan who?Ji b must sai gar mut dee ho,doom Ma lee ma du jar kee ho.
Thanks for sharing,buddy.Learn a lot from your channels in easy and simple ways.Hindi:Kee sai ho?T-Koo.Can/t lai lee kai ho can/t lai nei he?Can/t lai nei he kai ah mei tao mei key lai dar hung.Au bag dai bar kar kar hei.Bo ho ma sai he hei.Tao lee tao lee,Hindi,Hindu art dee hei.Mei,Hindi,Hindo art dee hei?Mei India kam kee hei ,kar kee hei.Au bag dai bar kar kar hei,easy art dee hei.Bo ho ma sai he hei.Bar hei bo ho got me hei?Kam beer jar dar ban lee "B lai"Bar hei bo ho bar lish hei?Chut dar sure lure kee mut.Mei jar lai ha hung,Bo ho tek kee hung.Bar mei link it.Mei ban lee.So kar lee ah.Ug lai hip see dai mei link it.So kar lee ah.Doom ah char in shan who?Ji b must sai gar mut dee ho,doom Ma lee ma du jar kee ho.
0:08 Trim extra space [TRIM command] 1:19 select blank cells. treat then all the same. [Go to special - (highlight range and F5)] 2:39 Convert numbers stored as text into numbers [paste special, multiply by 1] 4:59 Remove duplicates [DATA tab, remove duplicates] 7:21 Highlight errors [Go to special] 9:24 Change text to lower/UPPER/Proper case [command, LOWER, UPPER, PROPER] 10:54 break up concatenated text (e.g. street address) into separate columns [DATA, text to column] 13:15 Spell check [select range, press F7] 14:33 Find and Replace [ctrlH] 16:59 remove line breaks in text [ctrlH, find what tab = ctrlJ; replace with tab = space bar} 17:47 Clean (out unwanted characters from) text data (use asterix in find what and replace with white space]
You have an excellent teaching style. Very complete instruction without the unnecessary blab you find on many RUclips videos. Very knowledgeable, yet easy to follow and understand. Keep up the good work.
You are simply Amazing I am a Corporate Graphic designer and time time I receive Excel Documents where I require to do some tweaks and I always face problems, but now I know a place to go to where I get all the solutions with absolutely no nonsense. :)
Thank you so much for this video. I have been struggling with data cleaning and most of the videos I have been seeing are not useful but this video solve it. thank you once again!
Wow. I'm speechless. There are a few I knew Excel could do (ex. caps/no caps) but couldn't find it anywhere since I couldn't explain it properly. Learned a lot. Keep up the good work. I like the Ctl-H thing too. Extra step with Ctrl-F... No fluff, no hesitation, right to the point. My kind of tutorial. Thanks for showing, Nicole from Canada
I've been using excel for heavy analysis work for the past year. Even then, I have learned at LEAST 8 new things from your video. Wow. Thank you so much!
Hello, I've not even reachedd half way but found your video to be crisp and to the point. Just enjoying this crash course. Pls keep making it.... Thank u
Excellent video! Thank you so much. When the cursor is inside a block of data, press Ctrl + A to select the block of data instead of dragging the cursor. When copying down a formula in a column adjacent to existing data, select first cell to be copied, hover mouse over that cell's lower right corner until it becomes a cross and then double click to automatically copy down the formula or content of the first cell into the cells beneath it down to the last row of data in the adjacent column. This technique is faster than dragging down the cursor over the target cells. Thank you kindly.
i am glad to find your channel.the way you teach all these things its really easy to understand.keep posting all these videos..and one more thing your voice is amazing...
Simple everyday functions but never cease to learn something new to exploit different ways of using them. Really appreciate the versatility of Find/Replace feature that goes beyond finding and replacing text. Woah! 😲👏👏
1. Not Appear - Better replace with zeros and use formatting to show Text "Not appear. THanks to that pivot and formulas will work better. 2. Instead of looking for Errors it's better to create formula that handles the errrors, such as IFERROR. 3. Ctrl+J - brilliant! 4. (*) - also clever.
Thanks for sharing,buddy.Learn a lot from your channels in easy and simple ways.Hindi:Kee sai ho?T-Koo.Can/t lai lee kai ho can/t lai nei he?Can/t lai nei he kai ah mei tao mei key lai dar hung.Au bag dai bar kar kar hei.Bo ho ma sai he hei.Tao lee tao lee,Hindi,Hindu art dee hei.Mei,Hindi,Hindo art dee hei?Mei India kam kee hei ,kar kee hei.Au bag dai bar kar kar hei,easy art dee hei.Bo ho ma sai he hei.Bar hei bo ho got me hei?Kam beer jar dar ban lee "B lai"Bar hei bo ho bar lish hei?Chut dar sure lure kee mut.Mei jar lai ha hung,Bo ho tek kee hung.Bar mei link it.Mei ban lee.So kar lee ah.Ug lai hip see dai mei link it.So kar lee ah.Doom ah char in shan who?Ji b must sai gar mut dee ho,doom Ma lee ma du jar kee ho.
Nice tips...just to add I use pivot and concatenate columns to identify unique values and remove them when I have large MTD data, where only values and dates are different. If you have tips to clean large MTD and YTD data..please share.
Thanks for this quick and easy demo to clean up data! I want to download file with large amount of data for cleanup practice. Do you know the reliable source from where I can download it?
I have learnt too many things from your video. Thanks a lot. But in the last, I have a question. What if I apply HOME>Wrap Text instead of 17:20? Will there any difference? Thanks in advance.
is this one of the best videos on excel (unlike tons of other videos with duplicate content)? i ask this since youtube took a while to bring it to me..
The following data cleaning techniques are covered in this video: 0:00 Get Rid of Extra Spaces (leading, trailing, and extra spaces between words) 1:20 Select and remove All Blank Cells/rows 2:38 Convert Numbers Stored as Text into Numbers 5:00 Remove Duplicates cells/records 7:21 Highlight cells that contain Errors 9:24 Change Text to Lower/Upper/Proper Case to make it all consistent 10:54 Parse Data Using Text to Column 13:15 Spell Check (using a keyboard shortcut) 13:54 Delete all Formatting 14:33 Use Find and Replace to Clean Data in Excel
Excellent video and we particular like the section on removing duplicates as this is something we have been working on for many years, and although Excel has a very quick method of finding and removing duplicates we find that by combining advanced data matching algorithms with configurable lookup libraries can provide the most accurate results.
Thanks for the informative lecture. There is also a formula to apply when dates are resistant to routine formatting; the formula is =DATEVALUE(TEXT(A1,"dd-mm-yyyy")) . NB A1 is the cell number you want to change its Date format
Hi - I have a workbook with 13 sheets. Each sheet has a table which tracks weekly data. Each week I manually add a new row to the top of the table for the newest weeks data and update the formatting and formula in the new row, for each sheet. I then manually update formulas about the table which tracks MIN, MAX, SUM and AVG. Is it possible to automate these steps for all 13 sheets?
The CONCATENATE function does this. You would use a comma , to choose a new cell so if you had data in a1 b1 c1 & d1 you could join this by the formula =CONCATENATE(a1,b1,c1,d1) and it will do this: a1b1c1d1 to separate this with a comma & space you'd add this to the formula =CONCATENATE(a1,", ",b1,", ",c1,", ",d1) and you'd get this a1, b1, c1, d1
![[FREE EXCEL COURSE] Lesson 4 - Working with Cells and Ranges](http://i.ytimg.com/vi/B16UleW3uUM/mqdefault.jpg)
If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos.
Here are some other Excel tips videos you may find useful:
✅ How to Delete Blank Rows in Excel - ruclips.net/video/2t6gEKjTqvI/видео.html
✅ How to Remove Leading and Trailing Spaces in Excel - ruclips.net/video/EGien2dwG9M/видео.html
Also, I have made all of my Excel courses available for free. You can check these out using the below links:
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
💞
0:08 Trim extra space
1:19 select blank cells. treat then all the same.
2:39 Convert numbers stored as text into numbers
4:59 Remove duplicates
7:21 Highlight errors
9:24 Change text to lower/UPPER/Proper case
10:54 break up concatenated text (e.g. street address) into separate columns
13:15 Spell check
14:33 Find and Replace
16:59 remove line breaks in text
17:47 Clean (out unwanted characters from) text data
13:55 Deleting all formatting
For spell check when i pressed F7 , i am getting airplane mode on
@@sophialawrence6880 hit Fn + F7, Fn is your function key, located next to the 'alt' key.
@@sophialawrence6880 press Fn+f7
Do you use some API function to get time stamps or painstakingly do it manually.
I have taken to learning excel on a full time after my retirement in May 2017. First it started as a hobby and now it has become an obsession since it gives me a lot of happiness. I almost spend 4 to 5 hours going through all the excel videos that come in RUclips and practice each one of them. I can definitely say that the way you teach excel is simply fantastic. All the explanations are extremely crisp.
Hats off to your work
i was 8 years old when i watched this video. now im 15 and i wanna say that im the best at excel in the whole neighborhood, thank you sumit bansal
I've looked at about 15 excel videos and this one was the best and most clearly explained without excessive chit chat..This Professor rocks! thanks.
There are many excel teachers in the RUclips, but i must say the way you guys teach and summarise the functions are awesome. Well done and keep inspiring guys.
Thanks for sharing,buddy.Learn a lot from your channels in easy and simple ways.Hindi:Kee sai ho?T-Koo.Can/t lai lee kai ho can/t lai nei he?Can/t lai nei he kai ah mei tao mei key lai dar hung.Au bag dai bar kar kar hei.Bo ho ma sai he hei.Tao lee tao lee,Hindi,Hindu art dee hei.Mei,Hindi,Hindo art dee hei?Mei India kam kee hei ,kar kee hei.Au bag dai bar kar kar hei,easy art dee hei.Bo ho ma sai he hei.Bar hei bo ho got me hei?Kam beer jar dar ban lee "B lai"Bar hei bo ho bar lish hei?Chut dar sure lure kee mut.Mei jar lai ha hung,Bo ho tek kee hung.Bar mei link it.Mei ban lee.So kar lee ah.Ug lai hip see dai mei link it.So kar lee ah.Doom ah char in shan who?Ji b must sai gar mut dee ho,doom Ma lee ma du jar kee ho.
@@keithau8159 ruclips.net/video/-su8Z4j1p1A/видео.html
I am agreed!!👏
I didn't know about using Ctrl + J in Find & Replace box.. thank you, that would be very very useful someday.
To the point and very precise. Didn't waste a single second. Thank you for providing this.
Thanks for sharing,buddy.Learn a lot from your channels in easy and simple ways.Hindi:Kee sai ho?T-Koo.Can/t lai lee kai ho can/t lai nei he?Can/t lai nei he kai ah mei tao mei key lai dar hung.Au bag dai bar kar kar hei.Bo ho ma sai he hei.Tao lee tao lee,Hindi,Hindu art dee hei.Mei,Hindi,Hindo art dee hei?Mei India kam kee hei ,kar kee hei.Au bag dai bar kar kar hei,easy art dee hei.Bo ho ma sai he hei.Bar hei bo ho got me hei?Kam beer jar dar ban lee "B lai"Bar hei bo ho bar lish hei?Chut dar sure lure kee mut.Mei jar lai ha hung,Bo ho tek kee hung.Bar mei link it.Mei ban lee.So kar lee ah.Ug lai hip see dai mei link it.So kar lee ah.Doom ah char in shan who?Ji b must sai gar mut dee ho,doom Ma lee ma du jar kee ho.
0:08 Trim extra space [TRIM command]
1:19 select blank cells. treat then all the same. [Go to special - (highlight range and F5)]
2:39 Convert numbers stored as text into numbers [paste special, multiply by 1]
4:59 Remove duplicates [DATA tab, remove duplicates]
7:21 Highlight errors [Go to special]
9:24 Change text to lower/UPPER/Proper case [command, LOWER, UPPER, PROPER]
10:54 break up concatenated text (e.g. street address) into separate columns [DATA, text to column]
13:15 Spell check [select range, press F7]
14:33 Find and Replace [ctrlH]
16:59 remove line breaks in text [ctrlH, find what tab = ctrlJ; replace with tab = space bar}
17:47 Clean (out unwanted characters from) text data (use asterix in find what and replace with white space]
You have an excellent teaching style. Very complete instruction without the unnecessary blab you find on many RUclips videos. Very knowledgeable, yet easy to follow and understand. Keep up the good work.
I just got your video and saw it only for one minute and I am exited about the first presented function!
Excellent !!!
You are simply Amazing I am a Corporate Graphic designer and time time I receive Excel Documents where I require to do some tweaks and I always face problems, but now I know a place to go to where I get all the solutions with absolutely no nonsense. :)
Thank you so much for this video. I have been struggling with data cleaning and most of the videos I have been seeing are not useful but this video solve it. thank you once again!
Wow. I'm speechless. There are a few I knew Excel could do (ex. caps/no caps) but couldn't find it anywhere since I couldn't explain it properly. Learned a lot. Keep up the good work. I like the Ctl-H thing too. Extra step with Ctrl-F... No fluff, no hesitation, right to the point. My kind of tutorial. Thanks for showing, Nicole from Canada
Really very much useful. Your teaching method of teaching is so easy to understand and your speech is nice. Very useful tips. Thank you
I've been using excel for heavy analysis work for the past year. Even then, I have learned at LEAST 8 new things from your video. Wow.
Thank you so much!
Hello, I've not even reachedd half way but found your video to be crisp and to the point. Just enjoying this crash course. Pls keep making it.... Thank u
Excellent video! Thank you so much.
When the cursor is inside a block of data, press Ctrl + A to select the block of data instead of dragging the cursor.
When copying down a formula in a column adjacent to existing data, select first cell to be copied, hover mouse over that cell's lower right corner until it becomes a cross and then double click to automatically copy down the formula or content of the first cell into the cells beneath it down to the last row of data in the adjacent column. This technique is faster than dragging down the cursor over the target cells.
Thank you kindly.
💐💐💐
Very nice tip
Thank you. 🌻
@@parminderghai
c
I would say this is the most helpful video Ive watched recently although its already 2020! Thank you so much!
i am glad to find your channel.the way you teach all these things its really easy to understand.keep posting all these videos..and one more thing your voice is amazing...
Superb!!! Thanks Sumith. The way of teaching is excellent and with in a very short span of time.
One of the best videos on excel that I have ever watched
Straight to the point, covers each point thoroughly.
Excellent short presentation of very helpful tips. Thanks you.
You are a great and honest teacher - salute you -thanks once again.
The people who work with excel generallay, these hints and videos are very useful. Thanks.
Simple everyday functions but never cease to learn something new to exploit different ways of using them. Really appreciate the versatility of Find/Replace feature that goes beyond finding and replacing text. Woah! 😲👏👏
Feels like found Treasure in RUclips after many years , Great work
This video is a jem on internet. God bless you brother.
Thank you for taking the time to create this video!
If I could give this video another Like I would. I've saved it as a favourite and keep coming back to it. Awesome job; well done.
Glad you're finding the videos useful
I don't usually comment on videos, but this time I have to say: great tips and amazing explanations! Thank you man, you rock!
simple and time saving tricks ! Thanks for sharing
Very useful in day to day operations!
Excellent. hugely helpful. Many thanks...
1. Not Appear - Better replace with zeros and use formatting to show Text "Not appear. THanks to that pivot and formulas will work better.
2. Instead of looking for Errors it's better to create formula that handles the errrors, such as IFERROR.
3. Ctrl+J - brilliant!
4. (*) - also clever.
Thank you so much. I think your lessons are very helpful
Bro you have EXCELLENT Knowledge on Excel , great
Very good thank you but i want to ask you something would you plz make tutorial about stock in excel inventory
one of the best RUclips channel to learn Excel. Nice Explanation...
Good video ..thank you, as a data analyst , these tips are helpful and i have included in my data cleansing checklist before any analysis
No nonsense! Some really great content in a relatively short amount of time.
Thanks for sharing,buddy.Learn a lot from your channels in easy and simple ways.Hindi:Kee sai ho?T-Koo.Can/t lai lee kai ho can/t lai nei he?Can/t lai nei he kai ah mei tao mei key lai dar hung.Au bag dai bar kar kar hei.Bo ho ma sai he hei.Tao lee tao lee,Hindi,Hindu art dee hei.Mei,Hindi,Hindo art dee hei?Mei India kam kee hei ,kar kee hei.Au bag dai bar kar kar hei,easy art dee hei.Bo ho ma sai he hei.Bar hei bo ho got me hei?Kam beer jar dar ban lee "B lai"Bar hei bo ho bar lish hei?Chut dar sure lure kee mut.Mei jar lai ha hung,Bo ho tek kee hung.Bar mei link it.Mei ban lee.So kar lee ah.Ug lai hip see dai mei link it.So kar lee ah.Doom ah char in shan who?Ji b must sai gar mut dee ho,doom Ma lee ma du jar kee ho.
Thank you for the excellent presentation. Everything is clear and concise.
This guy is sharp and knows his stuff
Nice tips...just to add I use pivot and concatenate columns to identify unique values and remove them when I have large MTD data, where only values and dates are different. If you have tips to clean large MTD and YTD data..please share.
Wow! I don't know where you made this video but you helped me out here in Chicago just watching this.
You have used "=TRIM" in your videos too. No nonsense no time waste. Thank you.
Excellent video, very clear and precise
Thank you for this video. I came across a spreadsheet and it was garbage. Now it's nice and clean!
Excellent......In very short time covered many important excel tools....Thank you
Thanks for sharing,buddy.So generous at all.
Super AMAZING is that you are talking in English........ Incredible, unbelievable, overwhelming, awesome, etc.,
Enjoyed that 'Parse data using text to column' method.
I am so mad I didn't find this video sooner. Very helpful tips, thanks.
Thanks Sumit for this wonderful video, you have covered a lot real time scenarios in which I struggled and don't have answer how to easily fixed it
wonderfull tricks.
Thanks for this quick and easy demo to clean up data! I want to download file with large amount of data for cleanup practice. Do you know the reliable source from where I can download it?
Simple and useful tips , Thank you very much
This really is one of the Best tips post for Excel functions!
Wow, this is excellent. Thank you for uploading this video, you have no idea how helpful this video is.
Thank you.This really help me.More videos please.
Love the way you converted text to number
I have learnt too many things from your video. Thanks a lot. But in the last, I have a question. What if I apply HOME>Wrap Text instead of 17:20? Will there any difference? Thanks in advance.
Superb Video, exactly what I was searching for on the internet
Hey, follow this guy. He has pivoted into data analyst and has really helpful videos ruclips.net/video/axTt_5Zr46M/видео.html
Great video. I had a tough time converting text format to number format. I will what you have taught here. Thanks
Excellent Presentation
Excellent Sumit ji, You have explained everything with good examples in this video. God Bless. Thank you for efforts you have put in.
Wow... thanks Man... these tricks are so useful
You are a star sir. So useful.
amazing bro thanks a lot
You are a very good teacher
Stay blessed
Great work
This is the best video on data cleaning I have seen. Thanks. Please upload more on vlookup index and other useful techniques.
is this one of the best videos on excel (unlike tons of other videos with duplicate content)? i ask this since youtube took a while to bring it to me..
The following data cleaning techniques are covered in this video:
0:00 Get Rid of Extra Spaces (leading, trailing, and extra spaces between words)
1:20 Select and remove All Blank Cells/rows
2:38 Convert Numbers Stored as Text into Numbers
5:00 Remove Duplicates cells/records
7:21 Highlight cells that contain Errors
9:24 Change Text to Lower/Upper/Proper Case to make it all consistent
10:54 Parse Data Using Text to Column
13:15 Spell Check (using a keyboard shortcut)
13:54 Delete all Formatting
14:33 Use Find and Replace to Clean Data in Excel
Very useful video boss.
Big thanks to this video. As an Analyst, I found it very time-consuming to clean the data. This is very helpful.
Hey, follow this guy. He has pivoted into data analyst and has really helpful videos ruclips.net/video/axTt_5Zr46M/видео.html
Very helpful video thanks
Wonderful and simple presentation! Good job Sumath!
Excellent explanation!
nicely done, easy to swallow and to the point, thank you for your hard work. thumbs up
Excellent. Useful tips. Thank you.
VERY GOOD TIPS! I'm so happy to learn these new tricks. Thanks a lot and please keep it up!
Great tutorial..
No words for the explanation. Thx
Fantastic video, those data cleaning techniques are extremely useful for our daily excel work...Great Mr. Bansal 👍
I agree with you Mrinal, it's been an incredible class.
Hey, follow this guy. He has pivoted into data analyst and has really helpful videos ruclips.net/video/axTt_5Zr46M/видео.html
I love your video and thank you very much for doing this!
Thank you so much! Very helpful.
Great tips and tricks video! Thank you
Excellent video and we particular like the section on removing duplicates as this is something we have been working on for many years, and although Excel has a very quick method of finding and removing duplicates we find that by combining advanced data matching algorithms with configurable lookup libraries can provide the most accurate results.
Hey, follow this guy. He has pivoted into data analyst and has really helpful videos ruclips.net/video/axTt_5Zr46M/видео.html
Thanks for the informative lecture. There is also a formula to apply when dates are resistant to routine formatting; the formula is =DATEVALUE(TEXT(A1,"dd-mm-yyyy")) . NB A1 is the cell number you want to change its Date format
Hi - I have a workbook with 13 sheets. Each sheet has a table which tracks weekly data. Each week I manually add a new row to the top of the table for the newest weeks data and update the formatting and formula in the new row, for each sheet. I then manually update formulas about the table which tracks MIN, MAX, SUM and AVG. Is it possible to automate these steps for all 13 sheets?
Your videos are really awesome to understand , Thank a lot
Very neat useful tips, no faffing around straight into the "Functions"... very precise,very useful, very well done Sir!
Thank you for an informative tutorial.
Excellent tips.... thank you
Your videos really help. Thanks.
So helpful. Thank you
Love ur videos....I am not able to get the result for find and replace ( line break and removing brackets). Can u help me out..
Hello!
As you taught the method to convert text to column. Is there any way to do the opposite?
If yes then please suggest.
TIA
The CONCATENATE function does this. You would use a comma , to choose a new cell so if you had data in a1 b1 c1 & d1 you could join this by the formula =CONCATENATE(a1,b1,c1,d1) and it will do this: a1b1c1d1 to separate this with a comma & space you'd add this to the formula =CONCATENATE(a1,", ",b1,", ",c1,", ",d1) and you'd get this a1, b1, c1, d1
Use formula function *concatenate* to help you or text join feature.
Summit, great video and contents. Thank you for such useful video. Please help me to execute the result without showing formula
Thank you so much!
Those non printing characters were proving a real headache.