How to Join and Separate text in difference column | Excel Tips and Tricks #12
Join this channel to get access to perks:
/ @vireakphou
#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: • How to Highlight Auto the Active Row ...
How to create Bar Code in excel | Excel Tips and Tricks #10 : • How to create Bar Code in excel | Exc...
How to turn off Protected View in Excel | Excel Tips and Tricks #09 : • How to turn off Protected View in Exc...
How to insert pages number in excel | Excel Tips and Tricks #08 : • How to insert pages number in excel |...
How to make 10000 numbering in excel in 3 second | Excel Tips and Tricks : • How to make 10000 numbering in excel ...
How to manage overflow text in excel | Excel Tips and Tricks : • How to manage overflow text in excel ...
How to lock some cell with password in excel | Excel Tips and Tricks : • How to lock some cell with password i...
How to change columns heading from letters to Number in excel : • How to change columns heading from le...
How to show or hide formula bar on excel : • How to show or hide formula bar on ex...
How to show battery percent on iPhone : • How to show battery percent on iPhone
How to install Khmer keyboard completely on iPhone latest : • How to install Khmer keyboard complet...
How to show easy touch on iPhone iOS 14 | iPhone tips : • How to show easy touch on iPhone iOS ...
How to change youtube cover image | YoutubeTips & Tricks : • How to change youtube cover image | ...
How to customize widget and reset iOS 14 home screen : • How to customize widget and reset iOS...
How to record screen on iPhone without any app : • How to record screen on iPhone withou...
How to check duration of season ends on mobile legends : • How to check duration of season ends ...
New Updated | How to turn on speed boost in Mobile Legends : • New Updated | How to turn on speed bo...
How to change youtube light mode to dark mode on phone : • How to change youtube light mode to d...
Check out my popular playlist :
Excel tutorials 2020 : • Excel tutorials 2020
Blogger tips and tricks : • Blogger tips and tricks
Google Form : • Google Form
General Knowledge: • General Knowlegde
Technology tips and tricks: • Technology tips and tricks
Game : • Game tips and tricks
Computer tips and tricks : • Computer tips and tricks
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 !
~-~~-~~~-~~-~
Please watch: "How to lock some cell with password in excel | Excel Tips and Tricks #05 "
• How to lock some cell with password i...
~-~~-~~~-~~-~