|
|
I saw this question in Twitter this week: Anyone know a way to get an Excel cell to take over 255 characters w/o converting to pound signs ###? Wreaking havoc on something I'm trying Here's an example – in the following screenshot, cells B2 and B3 contain the same long string of characters. [...]
It's almost April, and the snow tires are coming off my car today, so spring must be just around the corner. That means it's time to start planning the garden. We don't actually plant anything in southern Ontario until the May 24th weekend, but a bit of planning will make it easier to survive the [...]
Well, you might not get a degree when you complete your courses, but there's lots of educational material available through YouTube. It's organized in a special section of the website: www.youtube.com/edu which features videos from YouTube's college and university partners. You can search for a specific topic, or view a list of [...]
Moved to the Excel Twitters archive: Excel Twitters 20090327
If you have a list of names in Excel, with first and last names separated by a comma, you can use an Excel feature to split the first and last names into separate columns.
Select the List
To start, select the cells that contain the names.
On the Ribbon in Excel 2007, click the [...]
Ron Coderre has updated his Convert Numbers to Words sample file, to fix some international issues that a user reported recently. The file uses a VBA function to convert a number to words, with options to specify a major currency, such as dollars and a minor currency, such as cents. The workbook has [...]
When you're troubleshooting an Excel worksheet, it may help to see the formulas temporarily, instead of the results. With the formulas visible, you can quickly check that the cell references are correct and the formulas are consistent. Tip: The keyboard shortcut to show or hide the formulas is Ctrl + ' (accent grave, may [...]
In the Google Reader, you can see a list of your RSS feeds, and group them into folders. Usually I assign a feed to a folder as soon as I subscribe to it. If I forget, then I can assign it later. One way is to click the Manage Subscriptions link, at the bottom [...]
Moved to the Excel Twitters archive: Excel Twitters 20090321
I've got a few different Signatures set up in Outlook 2007. Most of the time I use my business signature, but occasionally I'd like to use one of the others. Usually I use the Ribbon commands, but I've just discovered a mouse shortcut that makes it much easier. I'll be using the shortcut from now [...]

|
|