You can’t make document alterations more convenient than editing your xls files on the web. With DocHub, you can access instruments to edit documents in fillable PDF, xls, or other formats: highlight, blackout, or erase document fragments. Add text and pictures where you need them, rewrite your copy entirely, and more. You can download your edited record to your device or submit it by email or direct link. You can also convert your documents into fillable forms and invite others to complete them. DocHub even offers an eSignature that allows you to sign and send out paperwork for signing with just a few clicks.
Your records are safely kept in our DocHub cloud, so you can access them at any time from your PC, laptop, smartphone, or tablet. If you prefer to apply your mobile phone for file editing, you can easily do it with DocHub’s app for iOS or Android.
Hey, welcome back. Itamp;#39;s another dueling Excel podcast episode number 53. Iamp;#39;m Bill Jelen from MrExcel. We will be joined by Mike Girvin from Excel Is Fun. This episode is called Extract State Doozy of a question here, they have this long address. They want to get just the state from there. And the problem is like here where we had an extra comma, it was returning CH from Charleston instead of the state, right? So Iamp;#39;m sure that Mike is going to come up with a formula for this, but me, I am switching over to VBA and weamp;#39;ll knock out a quick little function VBA, just a way to do this without making my head hurt. So hold F11, insert a module, create a new function. Call a function, which is called GetState(MyText). All right, hereamp;#39;s what weamp;#39;re going to do. Weamp;#39;re gonna say for I = Len (MyText) to 1 Step - 1. See that? Thatamp;#39;s going to go backwards through each character in my text and we are going to start checking to see what it
