With DocHub, you can quickly undo street in spreadsheet from any place. Enjoy features like drag and drop fields, editable textual content, images, and comments. You can collect eSignatures securely, include an extra level of defense with an Encrypted Folder, and work together with teammates in real-time through your DocHub account. Make adjustments to your spreadsheet files online without downloading, scanning, printing or mailing anything.
You can find your edited record in the Documents tab of your account. Prepare, email, print out, or convert your file into a reusable template. With so many robust features, it’s simple to enjoy trouble-free document editing and management with DocHub.
in this video Iamp;#39;m going to show you how to separate addresses uh in your database if they are in one column and theyamp;#39;re all on one line first double check if itamp;#39;s really the case click on any cell and take a look at the formula bar you see that indeed this database actually has all the records in um one column on one cell in each uh on one line in each C C okay I suggest that you donamp;#39;t work in your original spreadsheet create a copy of it and make your changes there to do that right click the tab choose move copy check create a copy and um this will place a copy of the spreadsheet before data sheet letamp;#39;s call it original and leave it alone okay Iamp;#39;m going into data and first thing I will do is uh move the name of the state and the zip code from column n into column o for that I will use a formula hereamp;#39;s the formula it will read the right nine digits from column n and it will display it in column o let me type it out for you now you