I got an iPad for my birthday in November. I love it. ADORE it. (Thank you, Rosemary). I've been reading all the "So, you just got an iPad, what now?" articles I can find. So many of my friends and colleagues already have an iPad, I want to be sure I'm keeping up. This year, at a New Year's Eve dinner, several of us had our iPads out (Geek Dream Date) and were swapping app recs. As we were passing iPads around, I noticed that only I had 6 icons in the dock (the default is 4). "Hey, you guys know you can have 6 apps in the doc, right?"
Well, they didn't know. And I had my moment of geek superiority.
Carriage Returns in an Excel Cell (Mac)
I've been spending a little more time than I would like in Excel lately. And I often forget how to put a hard-return (carriage return) in a cell, particularly on a Mac.
Well, for those of you who want to know, it's control-option-return.
Counting Characters in an Excel Cell (Mac and PC)
I've been doing a little Facebook advertising work lately. They have character limits for the headline and the body of the ad. We're getting several ads approved by the client at a time, so they are all going in an Excel spreadsheet. I wanted a character counter so I didn't have to do it manually. Very easy.
- Create a column adjacent to the column where you have the text you want to count (technically, it doesn't HAVE to be adjacent, but for simplicity's sake).
- Use the formula =LEN(A1) (where A1 is the actual number of the cell whose characters you want to count)
- Done!
Now, it doesn't update in real-time (e.g. you have to exit the cell you're editing for it to update the count), but it's better than counting by hand!