How to Join and Separate text in difference column | Excel Tips and Tric...
Join this channel to get access to perks:
https://www.youtube.com/channel/UC3XH...
#ExcelForBeginners #ExcelTipsAndTricks #ExcelTutorials2020
Hello my friend today I going to show you How to Join and Separate text in difference column, If you not understand or need more video please drop comment below, I'll make the video for you. I hope my video tutorials is can help you, Please like and subscribe to get new video. Thank you for watching.
This is introduction : How to Join text in difference column
1- Use the concatenate formula : =CONCATENATE(G6," ",H6," ",I6)
. G6 is the first name
. " " is a space between first name and middle name
. H6 is a middle name
. " " is a space between middle name and last name
. I6 is a last name
2- Done.
----------
How to separate text in difference column
1- Select cell that you would like to separate
2- Go to Data
3- Click on Text to columns
4- Choose on Delimited and Click Next
5- Check on Space and click next
6- Choose the Destination by select on cell that you want to data separate to.
7- Click Finish.
8- Done.
For more information about technology, software download, computer tip, game, video tutorial and Hollywood movies. Please go to my blog : https://bigboxsoftware.blogspot.com/ or https://bigboxsoftware.net/
Check out my previous video :
How to Highlight Auto the Active Row and Column in a Data Range | Excel Tips and Tricks #11: https://youtu.be/KPkYWsNnznM
- How to create Bar Code in excel | Excel Tips and Tricks #10 : https://youtu.be/zQgq0PJKHtA
- How to turn off Protected View in Excel | Excel Tips and Tricks #09 : https://youtu.be/qXcPM7j51Tw
- How to insert pages number in excel | Excel Tips and Tricks #08 : https://youtu.be/WWtjeiL51NQ
- How to make 10000 numbering in excel in 3 second | Excel Tips and Tricks : https://youtu.be/5geXGLOkI_A
- How to manage overflow text in excel | Excel Tips and Tricks : https://youtu.be/mHFp8Lvz66s
Check out my popular playlist :
- Excel tutorials 2020 : https://www.youtube.com/playlist?list...
- Blogger tips and tricks : https://www.youtube.com/playlist?list...
- Google Form : https://www.youtube.com/playlist?list...
- General Knowledge: https://www.youtube.com/playlist?list...
- Technology tips and tricks: https://www.youtube.com/playlist?list...
- Game : https://www.youtube.com/playlist?list...
Computer tips and tricks : https://www.youtube.com/playlist?list...
If you would like to know something about computer tips track, Please drop comment below I will make video to reply you. Also do not forget to subscribe my channel to get new tips about computer, mac, phone, game, app … My channel is creating video refer to technology and video tutorial about computer for you upper 2 video a week.
Thank you for your time, And hope all my video is helpful for you, Have a nice day !
