AppleInsider | Apple Insider News and Analysis MacDailyNews - Apple and Mac News - Welcome Home TechChee.com, shop online for gadget, gizmo and hot tech stuff Mac Rumors: Apple Mac Rumors and News You Care About Chick-fil-A: Home ProfHacker Many of us have favorite tools that suit our workflows well, helping us accomplish our tasks and keep track of needed bits of information. Below you’ll find a list of applications, services, and utilities that I use almost daily. Workflow. I’m a big fan of ToDoist, my preferred task manager. For the way I work, it’s a better option than Apple’s Reminders. I know I know. Let’s backtrack a minute. A few weeks ago, coincidentally during Day of DH 2016, it was brought to my attention that Voyant, a web-based text analysis tool, had upgraded to Version 2.0. This has been a popular tool with ProfHackers (I’ve written about using it as has Brian), and the new version is a great improvement. a cleaner, crisper appearance better cross-platform and mobile device support (all tools in HTML5, no Flash or Java Applets) advanced search capabilities, including wil… Last week, I introduced readers to Installatron, a tool that’s very useful for backing up and cloning WordPress installations.
Extract usernames from E-mail IDs [using LEFT and FIND formulas in Excel] Posted on January 19th, 2010 in Learn Excel - 87 comments Today we will learn to use Excel’s LEFT and FIND formulas. But what fun it is to learn a new formula on a Tuesday? So, we will actually learn to use these formulas to solve the problem: “extract the username from an email ID” How is an email ID structured? Any email ID contains 2 parts – user name and domain name. For eg. in my email id – chandoo.d@gmail.com – chandoo.d is user name and gmail.com is domain. So how do we get the user name out? As you can see, username always starts at left and goes up to the symbol “@”. This is where LEFT() and FIND() formulas enter the scene. What does Excel LEFT formula do? Excel LEFT formula will let you cut a portion of text from left. So, to get the email username, we need to get all the letters in the left of email ID up to the location of “@” symbol. We use FIND formula. FIND formula gives the location of one text in another. FIND will throw an error (#VALUE!) (syntax and examples) Your homework: