How To : Use the Left, Mid, and find function in Excel 2007
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.
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.
There are over 425,000 apps in the iTunes App Store and the Android Market has over 300,000 available, which makes it really hard to tell which ones you want and which ones you don't. One of the best ways to find new mobile apps is from your family, friends and colleagues—thos ...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
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
When you first become interested in learning how to program, it can be difficult to find a place to start. A lot of questions come up, especially if you're new to the idea of programming entirely. After you pick which language you want to learn, you have to worry about how you ...more
Learn how to solve statistics problems that require you to find the regression line. Whether you need help studying for that next big stats text or just a hand finishing your homework, you're sure to be well served by this four-part free video math lesson from Salman Khan.
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
This video shows us the method to find the percent sign on Blackberry. The first step involves going to a place on the Blackberry where text can be inserted. This place is ideal for inserting a % sign. Look in the keypad carefully. There are various keys in it. Search for the ...more
Would you like to learn how to create amazing realistic reflections using GIMP? If so then you need to watch this video. Within 4 minutes you will be making amazing reflections. You can find the source files here. Hulldo will walk you through the simple steps of creating text ...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
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
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
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
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
What if I told you that you could read minds? You'd most likely think I was crazy, and you'd be right. But what I really meant is that you could make people think that you could read minds, something that's not the least bit crazy. Performing mind reading — and it is a perfor ...more
In this first demo of a 4-part series, learn how to set up labels for mass mailings using the Mail Merge feature in Word 2007. In this second demo learn how to select recipients to be part of the mass mailings by using a Microsoft Office Excel 2007 worksheet as the data source ...more
Two new and radically different ARGs (Alternate Reality Games) have burst into the news in the last week, and illustrate the very best of an innovative phenomenon: the commercial tie-in ARG, and the public service ARG. After video games grew beyond "fad phase" and entered the ...more
To insert a picture on your wiki page you first need to find the picure you want. Hit the edit button and click the image of the tree. Browse your computer to find the picture you want, click open, and then scroll down and click "upload" If your file does not upload, it may be ...more
To do this, you must be using Safari; make sure you are not using Firefox or another program. This can be very useful for quickly finding information on web pages. Press Command F. This will open up a toolbar on the top of the page which will ask you what you are searching for ...more
This video in the Education category will show you how to make any school paper look longer. Open the normal word document. Go to ‘edit’ and select ‘find’ and then to ‘replace’ tab. In the find what box type in ‘.’ (a full stop). Then, in ‘replace with’ box type in ‘.’. Now go ...more
The first step to getting over a broken heart is to change the contact information of your ex to do not answer. Delete all texts when they come. Do not look at it! Throw away all moments from your relationships. Leave it in the garbage can! If your ex wishes to have an item ba ...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
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
In this article, I'll show you how to send SMS messages with Python. You'll need Python 2.7 or later, urllib and urllib2. The code basically uses an online text messaging service to "POST" html data, as if a person was entering the data themselves. The uses for something like ...more
A DIY car laptop mount that uses the cup holder... You think texting and driving is bad, wait until it's true multitasking and driving. Ouch. The whole project cost around $30 bucks to make; schematics and loose instructions can be found here.
I have had a lot of people ask me, "How does my neighbor keep getting into my wireless?!". Chances are, these people are all using WEP, a deprecated wireless encryption protocol. Either that, or you are using one weak WPA passphrase. If someone can access your wireless networ ...more
Like the recent XSS 0day exploit found in the Mac and Windows versions of Skype, a similar one has been found in the Skype app for iPhone. The vulnerability allows an attacker to send a message that contains malicious JavaScript code in the "Name" parameter. This code can stea ...more
It may not be your number one spot for finding cool apps for your Android device, but the Amazon Appstore for Android is running a new promotion this week called "Geek Week," where eight of the most popular productivity and utility apps are now on sale for 48 percent off or mo ...more
Want to transfer all of your data from an old phone to your new HTC Desire HD? Learn how with this quick, official guide from HTC. Whether you're entirely new to the HTC Desire HD Google Android cell phone, interested in picking one up, or just out to learn a few new tips and ...more
Interested in storing text in an array within C++? Let this video be your guide. Whether you're new to Microsoft's popular general-purpose programming language or a seasoned programmer merely looking to brush up on the basics, you're sure to find much to take away from this he ...more
Need a hand picking the right text editor for the task of coding in Ruby? Let this video be your guide! Whether you're entirely new to Ruby on Rails 3 or are a seasoned developer merely looking to brush up on a few of the basics, you're sure to find much to take away. For more ...more
Do you have to send someone a really long text message? Did you know that you can do so from your computer? Watch this video to find out how easy it is to send an SMS message to nearly any cell phone.
In this clip, you'll learn how to draw text when working in MS Visual C++. Whether you're new to Microsoft's popular general-purpose programming language and IDE or are a seasoned developer merely looking to improve your chops, you're sure to find benefit in this free, officia ...more
In this clip, you'll learn how to copy and paste text within a VB application. Whether you're new to Microsoft's popular event-driven program language & IDE or a seasoned developer merely looking to improve your chops, you're sure to find benefit in this free Visual Basic prog ...more
In this clip, you'll learn how to export data from a Visual Basic app to an external TXT file. Whether you're new to Microsoft's popular event-driven program language & IDE or a seasoned developer merely looking to improve your chops, you're sure to find benefit in this free V ...more
In this clip, you'll learn how to implement simple text encryption and decryption in MS VB 6. Whether you're new to Microsoft's popular event-driven program language & IDE or a seasoned developer merely looking to improve your chops, you're sure to find benefit in this free Vi ...more
In this clip, you'll learn how to open and display a TXT file within a text field in your VB projects. Whether you're new to Microsoft's popular event-driven program language or a seasoned developer merely looking to improve your chops, you're sure to find benefit in this free ...more
In this next tutorial, you'll be finding out how you can create your very own glass effect. It can be applied to pictures and mainly text, to give it a cool shiny look. Of course before beginning, you'll need Adobe Photoshop downloaded on your computer and once that's done, g ...more
See how to create shadows for 3D titles in Apple Motion 4. Whether you're new to the Apple's popular motion graphics editor/compositing application or simply wish to get a little bit better acquainted with Motion 4, you're sure to find value in this tutorial. For more informat ...more
Although technology can make things easier for people, it can still serve as a dangerous tool when performing specific tasks. One in particular is driving. Texting, listening to music, and changing directions on a gps can all lead to an accident. In this next tutorial, you'll ...more
Looking to achieve an icy text animation within Apple Motion 4? This clip will show you how it's done. Whether you're new to the Apple's popular motion graphics editor/compositing application or are a seasoned digital video professional simply wishing to get better acquainted ...more
Ever wonder how to make your text spin in 3D around an object? This clip will show you how it's done. Whether you're new to the Apple's popular motion graphics editor/compositing application or are a seasoned digital video professional simply wishing to get better acquainted w ...more
Learn all there is to know about creating and animating 3D text in Swift 3D v6. Whether you're new to Electric Rain's popular Flash-oriented 3D modeler or just looking to better acquaint yourself with the program, you're sure to find much of value from this free video software ...more
Tired of text that walks the line? See how to create a circular text effect when working in Motion 3. Whether you're new to the Apple's popular motion graphics editor/compositing application or simply wish to get better acquainted with the program, you're sure to find value in ...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
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
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
"The answer is out there, Neo, and it's looking for you, and it will find you if you want it to." If you're a huge fan of the Matrix, why not make your own Matrix? Well, yes, it's probably a bit complicated but you can start with learning how to create a Matrix-inspired text i ...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
In this video one of the ultimate iPhone hackers, Jonathan A. Zdziarsk, demonstrates how to use a forensics toolkit to recover deleted text messages on an iPhone. But wait - there's more! Not only can you access text messages, but almost any other data on an iPhone as well. We ...more
Most people find the default SMS background for the iPhone fairly dull, so why not spice things up? Thanks to Cydia and some clever hackers, there is now a way to modify the background of your text messages! Here is the source that needs to be added to Cydia: http://iphonesch ...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!
Bill Myers shows how to quickly animate text and titles in Sony Movie Studio and Sony Vegas using the intro title from the LOST TV show as an example. Find more like this at http://www.bmyers.com
This tutorial shows you how to read text from a text file into a C# application. Use the stream reader object found within the system IO name space.
With a lot of Null Byters playing around with Linux because of its excessive use in the hacking world, some of you are bound to run into some trouble with the installation at some point or another. If you make a mistake, or you're intimidated by the wonky-looking installation ...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
Have an HTC smartphone? Chances are that some of your stored personal data has been hijacked by malicious apps on your device. Android apps that have permission to access the Internet, which is pretty much every ad-supported app out there, can snag valuable information such as ...more
In order to apply MLA format in MS Word 2007, you will need to change the lines and spacings. Press Control + A. This will highlight all of your typing. Then, click on No Spacing. Scroll to Times New Roman, in the font style drop down menu. Change the font size to 12. Change t ...more