With DocHub, you can quickly cut clause in excel from anywhere. Enjoy features like drag and drop fields, editable text, images, and comments. You can collect electronic signatures safely, 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 excel files online without downloading, scanning, printing or mailing anything.
You can find your edited record in the Documents tab of your account. Create, send, print, or turn your document into a reusable template. Considering the variety of advanced tools, it’s simple to enjoy smooth document editing and management with DocHub.
in this video weamp;#39;ll be looking for vlookup but something advanced that is using a trim function normally the data which you get in the company is not sorted or it is not properly sorted with these spaces letamp;#39;s see how it is I have a data here that is top products product and quantity price and thatamp;#39;s the data I want to find out using this data that is look of value and I want the price for this now Iamp;#39;ll just show you something here if I double-click and if you see thereamp;#39;s a space in this mobile text with help of this mobile I want the price but the same mobile space if I click here in my mean database there is no space so if you use the same formula it will throw an error message so how do I remove this space so you remember we have seen thereamp;#39;s a trim function trim will remove unwanted spaces between the text and then I can use the free loca function so we look up inside that Iamp;#39;ll use a trim function and Iamp;#39;ll type here so