When you want to apply a small tweak to the document, it must not require much time to Separate columns log. This type of simple action does not have to require additional training or running through handbooks to learn it. Using the right document modifying resource, you will not take more time than is necessary for such a swift change. Use DocHub to streamline your modifying process regardless if you are an experienced user or if it is the first time using an online editor service. This tool will require minutes or so to figure out how to Separate columns log. The only thing required to get more productive with editing is a DocHub profile.
A simple document editor like DocHub will help you optimize the amount of time you need to spend on document modifying regardless of your prior experience with such resources. Make an account now and enhance your efficiency immediately with DocHub!
hello and welcome to Microsoft Excel separating data into separate columns brought to you by shift key solutions and I am Eric Ripley okay in this video tutorial were going to be talking about two separate formulas to use with functions my goal in this example here is to take this column of information right here and I want to separate the data out of here I want to chop it up but I want to maintain this column of information for office location so what Id like to do is for the extension column I want to be able to take out that last four extension from each of these entries and I want them to populate here in this column and then next to that in the building column I want to cut out the name of the building like lab central HQ and so on and I want that to populate here by itself and separately while maintaining this column of information alright so the way Im going to do this is Im going to go to cell h4 here and Im going to start my formula like any other formula with an equal