What's the Easiest Way to Convert Data in Spreadsheets?

http://geeks.pirillo.com - http://live.pirillo.com - 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? http://chris.pirillo.com Distributed by Tubemogul.

Category:

Science & Technology

Tags:

• blog
• database
• excel
• gadgets
• help
• information
• office
• open
• pirillo
• processor
• spreadsheet
• video
• word
• wordpad
• review
• geek
• geeks
• chrispirillo
• lockergnome

[Sk0alRebel]

Pirrillo you were on g4 for such a short time....your stream show sucks hard...I know of techs in rural southern states better then you. You suck...your a one hit wonder....and your a spoiled brat. I know this doesnt mean anything but you really are a faget. If your gonna stream your whole fucking life do somthing. God you gay boy.

[ScottieDM]

In your phone number example, I would think you could insert an extra column (and hide the original). And then use character manipulation functions to pick out pieces of the number and reassemble them with the formatting bits in place.

Another possibility is to click on the column head to select the column, copy/paste into a decent programmer's text editor. Then use the advanced search/replace (reg-ex), or even macros in the editor, to fix the data. Then copy/past back into your column.

[nowhoney]

Thank you. That was informative and fun to watch too!

You are totally hilarious. I can see you as an actor too!!

[whatatidymess]

What mic are you using?

[2wild2function]

I love you thanks ;)

[WindowsGuru84]

Great video, I use this a lot now :)

[chubz1337]

chris is this like conditional formating in excel? I think the microsoft office suite has these covered. Although what i like about this is that its online.

[duanebproducions]

cool mac