Category Archives: Software Tips

EXCEL: How to extract text before a comma, space or period [SOLVED]

Excel tip:  If you try to extract text before a space ” “, comma “,” or period “.” in Excel you may try something along these lines: =LEFT(A2,(FIND(” “,A2,1)-1)) However, if you have non-matching records, i.e. something without a space in the previous example then you will get the following result: #VALUE! Since that is probably not what you wanted, try the following: =IFERROR(LEFT(A2,(FIND(” “,A2,1)-1)),A2) Which will result in either (A) the shortened result (where applicable) or (B) the original

Adjust WordPress Divi theme footer text [SOLVED]

Question: I am trying to adjust the footer text on a Divi based theme but cannot find it anywhere in the PHP code! How do I adjust the footer text in a Divi (child) WordPress theme? Answer: Good question! You can adjust the footer text via the theme customizer: #1 Login to the WordPress admin area and go to Divi -> Theme Customizer #2 Choose: Footer #3 Choose: Bottom Bar Voila, your theme’s footer text has been edited. I hope this helps! 🙂

How to adjust Picasa collage output size [SOLVED]

Question: I am creating a collage in Google’s Picasa application and I cannot get it to be the right aspect ratio for my paper which is 8.5×11 inches. Can you help? Answer: If you go to collage settings in Picasa, you can select the “Page Format” and choose something other than the default HDTV. Please see this screenshot for an example: I hope this helps 🙂

Photoshop CC fix D3DCompiler_47.dll is missing from your computer… [SOLVED]

A question from reader Henry: Hi. Today I did a fresh install of windows 7 pro on my lenovo thinkpad. Then I try to install adobe photoshop cc but I got an error when running the application: “D3DCompiler_47.dll is missing from your computer….” I reinstalled everything but that did not help. Can you help me with this dll problem? Thanks, –Henry Dear Henry, It looks like you are encountering the following error: Please find the following update for your Windows 7

Cinemagraph apps: Plotagraph, Zoetropic, Plotaverse +more

If you are looking for an easy way to add some pizzazz to your still photos, you may want to try making a cinemagraph. In the past, it required quite a bit of time to craft a cinemagraph utilizing fairly expensive programs. Now, however, it can be done on your phone in just a few minutes (or your laptop, tablet, PC if you so desire) at minimal to no cost. As an example, I tried Zoetropic on my Note 8 (Android) and within about

Keep formatting in Excel when copying/pasting from web page

Question from B.G.: Sorry to bother. How can I export and keep the integrity of the web page table columns? When I copy and paste to excel, it puts all data to 1 row. Answer:  Good question! Please find the steps below: Instructions In your web browser window showing the table/report, press CTRL+A (to select all) Then press CTRL+C (to copy) Switch to a blank spreadsheet in Excel, press CTRL+V (to paste) That should result in a nice separate set of

Fatal Error! PIL._imaging.pyd [SOLVED]

Question. I recently had the following popup unexpectedly on my Windows laptop: Fatal Error! PIL._imaging.pyd could not be extracted! I was surfing the internet on my laptop and I am worried that I might have a virus 🙁 Can you help me identify what caused that error? Thx! -Josh Silvija Answer. Hi Josh! Thank you for your question. Fortunately, that “fatal error” should not be an issue. Specifically, I have seen that error occur when Google Drive (now Google Backup and

How to change the Font color in Foxit PDF reader [SOLVED]

How to change the Font color of the typewriter type tool in Foxit: Select the “Comment” tab, Select the Typewriter tool and click on your text box Highlight your text (you may need to double-click it first) Select Font Color under the “Comment Format” tab and choose a color Voila, you can now adjust the “typewriter” tool font settings however you like! 🙂