Tag Archives: text-field

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: