DocHub makes it quick and simple to conceal address in spreadsheet. No need to instal any software – simply add your spreadsheet to your profile, use the easy drag-and-drop user interface, and quickly make edits. You can even use your PC or mobile device to modify your document online from any place. That's not all; DocHub is more than just an editor. It's an all-in-one document management platform with form creating, eSignature features, and the ability to let others complete and sign documents.
Each file you edit you can find in your Documents folder. Create folders and organize records for easier search and retrieval. Furthermore, DocHub guarantees the protection of all its users' information by complying with strict protection protocols.
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