What’s the Easiest Way to Convert Data in Spreadsheets?
Add to iTunes | Add to YouTube | Add to Google | RSS Feed
If you need to calculate numbers on your computer, you use a spreadsheet. You may even use a spreadsheet to keep track of names, addresses or phone numbers. How annoying is it if people don’t put certain elements into fields on a spreadsheet? Say for instance someone has over 400 phone numbers in a spreadsheet, but none of them have dashes between each subset. How much of a pain would it be for you to have to manually edit each and every one of those fields? This is where Magic/Replace can come in handy.
You can easily clean up your data, without a magic wand. Upload your saved spreadsheet, or paste in what you need to work with. Edit only one row of your text, such as a phone number (by adding dashes or parenthesis) and click the “update” button. Magically every row of your spreadsheet will update with those changes in the same columns.
How easy is this? This is a million times better and faster than attempting to edit each field by hand. That would take you hours! I love these web-based tools. Keep them coming!
Want to embed this video on your own site, blog, or forum? Use this code or download the video:
Have you ever heard of Traffic Blazer? Submit your business info to more than 200 search engines and directories and position your Web site for top rankings with Google and other leading search engines - it's available through GoDaddy. Plus, as a listener of The Chris Pirillo Show, enter code CHRIS2 when you check out, and save an additional $5 off any order of $30 or more. Get your piece of the internet at GoDaddy!
Recent Comments