J.D. Hodges - jdhodges.com since 2000 (4)

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

Monday, 2018.12.31 J.D. H. Leave a comment

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

Enable night light mode on Alexa

Monday, 2018.12.31 J.D. H. Leave a comment

If you have an Amazon Alexa device with a light right (most Echo Devices) you can enable a night light skill. Here is the developer’s app info: Alexa Night Light Skill Credit to CNET for the tip:

Adjust WordPress Divi theme footer text [SOLVED]

Sunday, 2018.12.23 J.D. H. Leave a comment

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 do I enter the unlock code on my Samsung Galaxy Note 8? [SOLVED]

Monday, 2018.12.03 J.D. H. Leave a comment

Question: How do I enter the code to unlock my Samsung Galaxy Note 8? Answer: Go to your phone’s dialer and enter the following code: #7465625*638*# After entering that code you will be prompted to enter your unlock code 🙂 NOTE: these instructions work for AT&T based Note 8’s and should also work on most other GSM carriers.

How to adjust Picasa collage output size [SOLVED]

Tuesday, 2018.11.27 J.D. H. Leave a comment

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 🙂

Well pump resources and Grundfos AC DC submersible pump info

Friday, 2018.11.23 J.D. H. Leave a comment

SQFlex Problems — northernarizona-windandsunhttps://forum.solar-electric.com/discussion/801/sqflex-problemsHi I am new here. I have a problem that has totally stumped me {so far} I have a SQflex 11 SQF 2 200 Grundfos 6 SQF-2 capabilities — northernarizona-windandsunhttps://forum.solar-electric.com/discussion/23101/grundfos-6-sqf-2-capabilitiesHello all, I have a situation that needs addressing soon. About 5 years ago, I had a well drilled close to my house. Both the quality and the quantity of the water leave something to be desired. Now… Submersible Pumps and multiple check valves? | Terry Love Plumbing

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

Friday, 2018.11.23 J.D. H. 2 comments

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

Colorado Theater Reviews

Thursday, 2018.10.25 J.D. H. Leave a comment

Looking for a good source of theater reviews in Colorado? Look no farther than OnStage Colorado: Also, if you have a theater-related event that you would like to add, there is a handy-dandy form for that as well: https://www.onstagecolorado.com/events/community/add Enjoy, and happy theater viewing! 🙂