How To : Use the Mid and Find functions in Excel
Learn how to use text functions like mid and find to extract characters from a larger text string within a cell in Excel.
Learn how to use text functions like mid and find to extract characters from a larger text string within a cell in Excel.
In this Electronics video tutorial you are going to learn how to magnify to edit text on an iPhone. This video is a part of a series of tips on iPhone finger tips. This is very simple and easy to do and takes practically no time to complete. If you wish to add something to a l ...more
Whether you're new to Adobe InDesign or a seasoned graphic arts professional after a general overview of CS5's most vital new features, you're sure to be well served by this official video tutorial from the folks at Adobe TV. In it, you'll learn how to Take the frustration out ...more
Citizen Engineer is an online video series about open source hardware, electronics, art and hacking by Limor (`Ladyada') Fried of Adafruit Industries & Phillip (`pt') Torrone of MAKE magazine. In part one of this episode dedicated to phone hacks, you'll learn how a how to bui ...more
iOS 5 introduces an incredible feature that isn't very well known called "Shortcuts." It allows you to use automatic text expansion for whatever abbreviations you want. This is a great way to type several letters into your iPhone, iPad, or iPod touch and have them immediately ...more
In this video tutorial, find out how to copy and paste HTML links embedded in the text with a breeze. No longer will you have to worry about re-entering every single link one by one. This video will give you a quick and easy solution to solving your most worrisome problem. Enjoy!
This is a tutorial showing you how to easily hack flash (.swf) games! You only need two things: A flash game (in .swf format) and Flasm (an amazing flash disassembler). Getting Flasm Download Flasm Flasm can be downloaded from the no|wrap.de website. Save & Extract Save ...more
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 190th installment in their series of digital spreadsheet magic tricks, you'll learn how to rearran ...more
In this video, learn how to send & receive text messages from your computer (Mac or PC) using your email. Is instructed in this video, you will need to find your cell phone service provider, which can be found by copy & pasting the following link: http://en.wikipedia.org/wiki ...more
If you've spent a ton of money on your newest smartphone, you will want to make sure it's secure. In this tutorial from the experts at PCWorld, learn exactly how to activate safety mechanisms on your Android. With these options you can set a complicated passcode (so that anyon ...more
Give FireFox the power to spellcheck all text fields on a webpage. Watch this video with Tekzilla to find out how!
Creating text that catches the eye can be difficult. One great trick is to have your text actually composed from an image. Using Photoshop CS4, you can quickly create professional-looking text from a single or multiple images. Watch this video tutorial to find out how.
If you are anxious to get the new iPhone 4G and aren't sure if you are eligible for the upgrade offer, check out this tutorial. With a quick dial you will find out if you qualify. This only takes seconds to do, so give it a shot - and it won't cost you any text messaging fees ...more
Some of you may stick with your iPads, but for those looking for a similar Android version, you finally have a winner. To master your new Motorola XOOM from Verizon Wireless, check out the product support page. There, you'll find interactive walkthroughs for getting started, ...more
At first, the Black Ops 1.04 patch seemed like a godsend. It was supposed to fix the horde of issues plaguing Call of Duty: Black Ops on the PlayStation 3. But when PS3 users started downloading and updating Activision's 1.04 update, they found that the supposed savior of onl ...more
Since its launch in 2001, Wikipedia has become the number one reference site on the web, used by anyone and everyone, written by anyone and everyone. With over 18 million collaboratively written articles, there's backgrounds and descriptions on practically everything—if it exi ...more
If you loved The Da Vinci Code by Dan Brown, then listen up— there's been a new discovery found hidden within Leonardo da Vinci's most famous painting— the Mona Lisa. An Italian researcher named Silvano Vinceti sparked a new controversy over the world's most famous painting w ...more
Why make a flip book? Because all animation – even stick-figure Flash animation and multilayered, highly technical 3-D effects – is built on, and can benefit from, the basics of the craft first developed by artists working at the beginning of the last century. And while fancy ...more
Despite the recent problems with the 1.04 update for PlayStation 3 gamers, Call of Duty: Black Ops remains a juggernaut for Activision in the gaming community, and its sales alone prove it. Black Ops was released on November 9th, 2010, and in its first five days on the market ...more
Adobe Photoshop is a great program to have on your computer, because you're able to do so much. From editing photos that you find online or in your own camera to creating your own from scratch. Photoshop is used for a variety of different reasons. In this tutorial, you'll see ...more
Simple SDK demonstrates how to add icons to your iPhone applications using XCode. Find your desired app and right click on it to designate that you want to open it with Gimp. Use the rectangle tool to crop the image to a square size. Add text to the image as desired. Then, sca ...more
Computer forensics expert Steve Burgess gives a highly informative tutorial on how to recover deleted emails in Outlook and Eudora. The most critical factor affecting the recoverability of deleted web-based emails, according to Steve, is whether the PST file, which stores all ...more
In this video by PI Classroom you get to learn how to remove the sim chip from an i-phone. The video provides a step by step process for removing the sim chip. The only tool required is a paper clip. *Turn the i-phone on its head so that the power button and the plug for the h ...more
James Marey teaches how to test whether your Anti virus is still working perfectly. First right-click anywhere on your desktop, go to 'New' and select 'Text Document' to open a new document. Now find some text containing a virus from the internet or you copy the text from the ...more
This video tutorial from Mark Dusting shows how to create and edit wiki page in Wikispaces. To start, open internet browser and go to www.wikispaces.com. Enter your registration information (username, password, email address)in Get started section. Once you're done click Get ...more
Certain aspects of Windows User Interface are not customizable like the text of the start button in Windows XP. However you can use certain tools and follow a procedure to change the default text of the start button. To do this you have to use a tool called Resource Hacker. No ...more
In this tutorial, we learn how to tether an iPhone 3G or 3GS. First, go to Cydia, then manage, then sources, and add "sinful iphone repo" to your phone. Now, click into the source and find the text that says "enable tethering" and choose which phone you have. After this, you w ...more
If you do any amount of graphic design or layout design, then you know the importance of using kerning when working with typeface. This Inkscape software tutorial shows you how to manually kern text within Inkscape. This isn't the best graphic design software, but it is open s ...more
First of all you have to open the 'notepad'. Now you have to type in "<html>" in first line. Write "<head> in second line. Write "<title>this website contains text wrapped around images</title>". In the fourth line you have to type '<body bgcolor="#999999">'. This shall add a ...more
Since PDF files are so popular in both our daily life and work, we see them everywhere. And sometimes we find there are terrfic images or text in the PDF files and we want to save them as seperate files for future use, such as in a presentation or post. Here's the question: ho ...more
In this video tutorial you will learn to use Photoshop to create text that resembles what you often find in video games. Learn to use the different options on Layer Style to achieve the effect you want. This example uses "Battlefield" font, a freeware font which you could find ...more
This is the first of a multi-part series on steganography techniques. Steganography, the art of hiding things in plain sight, has existed for a long time, and in many forms. When you manipulate the alphabet to have your own cipher and decipher, this is considered steganography ...more
In this how to video, you will learn how to take text from one location to another. This is known as cutting and pasting. First, open your word processor. Next, go in to your browser and find a website with text that you want to copy. Highlight a line of text. Next, right clic ...more
This video demonstrates uses of the left, mid, and find function in Excel 2007 to pull out specific pieces of text from a longer text string.
MapForce supports flat files as the source and/or target of any mapping involving XML, database, EDI, web services or other flat file data. In this how-to, you'll find instructions for mapping data from arbitrary text files (such as log files, CSV, fixed-width, and other legac ...more
Mastering your Excel skills? Have a busy Excel workbook or spreadsheet that needs to some organizing? In this two-part tutorial, learn how to pull text from cells & separate them into multiple columns in MS Excel. You will learn how to use the LEN(), FIND(), LEFT(), and RIGHT( ...more
Photoshop is all about being creative. The more you know, the better you become at mixing certain tricks and techniques to make amazing pieces of digital photography. But there are so many it can take a good chunk of your time to fully understand the power that Photoshop holds ...more
To the displeasure of many loyal Firefox users, Mozilla has been deploying what seems like a new marketing strategy to "catch up" to Google Chrome. I have no idea if this is because the version number is higher than theirs, but it is downright annoying. It's not all complaints ...more
In programs such as Microsoft Word moving text around can save quite a bit of time and for some be easier than re-typing whatever it may be. It's an easy task, but it entirely depends on what kind of computer you own, whether it's a Mac or a PC. In this video tutorial find out ...more
Take a look at this instructional video and learn how to create space in your note containers and move pages in Microsoft Office OneNote 2007. See how much control you have over how your notebook is set up, from a few words on a page to entire pages to whole sections. You'll a ...more
If you are finding it difficult to read certain text when viewing a web site you can scale it up and down to suit your needs. However, by default, many web browsers (e.g., Internet Explorer and Firefox) do not make it obvious that you can do this; effectively, they hide these ...more
In this video tutorial, Gary Rosenzweig of macmost.com takes a look at how to use the Keyboard Viewer to easily find and insert special characters and accent marks into your text documents. Très chouette!
If you’ve never heard of the term search engine optimization or SEO, then your website probably isn’t optimized for search engines and it’s hindering your site’s ability to get all of the traffic that it should. Read on for an explanation of what this entails and how it can he ...more
After the media outcry of Google Buzz's privacy issues, Google has set its goals on making the privacy parameters of Google+ simple to learn and as explicitly manageable as possible. No small feat. The approach has been to make the process of organizing your friends, contacts ...more
This place lets you post profiles WITH LINKS, images, shows, resources, all free. Best part...RANKS HIGH ON GOOGLE! worth the hassle of setting up a profile. http://www.artslant.com/la/main Pick the city or region you are from, then add away!! make sure you enter the links w ...more
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 11th installment in his "Highline Excel Cla ...more
Graffiti is a well known art form that some people really don't consider an art. It can be a very difficult art form to practice that requires time and patience in order to create a great looking piece of work. So in this tutorial, you'll find out how to draw and shade the wes ...more
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 191st installment in their series of digital spreadsheet magic tricks, you'll learn how to how to ...more
Here we will be making a website page layout for your Myspace account. A very common thing that people find difficult is the alignment of things such as text boxes and other DIV's. This video will demonstrate the proper meaning of alignment, as we have an already misaligned pa ...more
This Lynda tutorial goes over the various GREP meta characters that can be found in InDesign CS4. These characters describe a variety of things, including specific characters, how often characters may repeat in a text document, location, or conditions to searches (for words or ...more
If you need to build a SQL query, you can choose one of two alternatives. The first and a rather old way is using a console. But if you build your queries in MySQL console, you have to remember all the commands and keys. This is not a convenient way, because query execution is ...more
This walkthrough will help your through the entire gameplay of Lost Planet 2 for the Xbox 360. Lost Planet 2 is the sequel to the third-person shooter Lost Planet: Extreme Conditions, and besides the Xbox 360, is also available for the PlayStation 3 and Windows. It takes place ...more
Welcome to part three in a series about steganography, the art of hiding things in plain sight. We are practicing steganography because it can be a useful skill if you don't have access to encryption software, or need a quick solution to make sure the sender and recipient are ...more
ExcelIsFun will show you how to use indirect text and substitute in Excel. Select any date and product and create an intersession. Use Vlookup to look up your columns. Use the match function to find the value range. To do the same thing with dates, highlight the dates and name ...more
Sometimes, the text on a computer can be so small that it can be very difficult to read. Especially when you're using a web browser. So what do you do? Enlarge the print of course! In this video tutorial, find out how to use various methods on how to make text more readable fo ...more
This video shows you how to use the InDesign Find/Change command. You learn how to search for characters and formats in text, and search for attributes and effects in objects, glyphs, and patterns. You also learn how to save a search to reuse later. Use the Find/Change command ...more
ExcelIsFun shows you how to detect if a cell has a number or text. The first thing he explains is to find out what are the different types of things that can go into a cell. Next he talks about the use of "OR" and "IsNumber" to make it possible to determine if a cell has a num ...more
Want a little bit more from your text editor? This video clip from CNET TV will show you how to find a suitable replacement for Microsoft Windows' Notepad. For details, including step-by-step instructions, and to get started finding, downloading and using a Notepad replacement ...more
Don't you hate it when you go to print your term paper or document and find that paragraphs or sentences are cutoff? Well, this tutorial will show you how to link text together using Quark Express so each page will start and finish just where you want it to. A must for any pag ...more
Before you go running off to the Apple store, you may want to educate yourself. DVICE is kind enough to compile the 20 biggest complaints about the iPad from a whole slew of reviewers. 1. Upscaling makes old iPhone/iPod Touch apps ugly. "Here's the problem: It looks terrible ...more