For something that seems like it would be a pretty common requirement, turns out there isn’t a “built-in” easy way to delete blank / unneeded rows from a Microsoft Excel worksheet.
Well here are 2 nice methods, clearly detailed out:
Method 1 – For removing empty rows
Method 2 – For removing rows that contain “blanks” and other unwanted data
For the first time ever today after using various Macs for 10+years, I was suddenly met with this screen upon launching FaceTime:
How to fix this?
A restart (as with most things) sorted it out for a short while, but the issue returned again after the next time that the system re-awoke from sleep mode. A little Googling suggested running the following commands in turn from a Terminal window:
sudo killall VDCAssistant
and then after that, this:
sudo killall AppleCameraAssistant
And that’s seems to do the trick!
This just came across my radar as yet another reminder of why it’s so important that you keep System Integrity Protection enabled on your Mac (if your version of OSX supports it).
Recent Chrome update renders Mac’s with SIP disabled (or no SIP at all) un-bootable
Consider yourself warned!
Super handy tip here: how to extract data from between parentheses “( )” in Microsoft Excel. Just create a new column, and in the first cell of that column, enter this formula:
Note: The formula above assumes that your “target” column that has the parentheses is column “A” and the first row 1 has a value with a parentheses in it. If either of these are not the case, just change “A1” everywhere in the formula to match your first target cell that does have parentheses you want to extract from.
And that’s it! Just copy that formula over to the rest of the rows in your new column and you are all set!
To Extract text from parentheses, use this formula in a new column, assuming the target column is column “A”:
Note: Change “A1” accordingly to match the column and specific cell that you are targeting, then copy that formula to all other cells in your new column. Done!
And then to remove the text and the parentheses from all values in a column:
- Select the entire column
- Do a Find and Replace
- In the “Find what” box, enter this: (*)
- Click “Replace All”. Done!
A handy little pro tip for Mac OSX users – scenario: you have a Finder window open to a certain directory and you want to open another Finder window to the same directory, perhaps to put side by side with the current Finder window.
Just do this:
Press cmd + ctrl + o in Finder without any folders or files selected in that window.
Or if you do have a folder selected, cmd + ctrl + o will open a new Finder window into that selected folder.
Came across this very neat and handy site to help with writing or validating that your crobtabs are scheduled correctly: