SOLVED: Video: How to Separate Numbers From Letters In an Excel Text String

UPDATE: Oct 6 2016 – Before you spend a lot of time on creating a formula to separate text from numbers in Excel, watch our two minute video on how to use Excel’s little used but totally awesome FLASH FILL function to do this work for you. UPDATE: Jan 18, 2017 – Ezekiel from New Mexico pointed out that the code was not translating properly from HTML and that there was a missing file.   Both…

SOLVED: Video: How To Change Outlook Attachments From Linking to SharePoint OneDrive

If you are attaching files from your Office365 Onedrive Sharepoint cloud storage using Outlook 2016 you will find that it provides a lovely drop down showing you your recently edited files.  If you select files from that list and they are stored on OneDrive / SharePoint what it will actually attach is a lLINK to your files and not a copy of the actual files. Microsoft’s argument is that this new feature lets your recipients…

SOLVED: VIDEO: How to Select Copy Paste Only The Visible Cells in Excel

If you want to select copy paste only the visible cells in Excel: In Excel 2007, 2010, 2013 or Excel 2016, select the cells you are interested in On the HOME tab, click SELECT GOTO Click GOTO SPECIAL Click VISIBLE CELLS ONLY Right click on the cells you selected in step 1 and click COPY Paste the cells wherever you want and you will see it took only the visible cells Share This With Your Friends Now:

SOLVED: How To Fix Error 2503 2502 On Windows 10 When Installing Software

If you are installing (or configuring) software on your Window 7, 8 or 10 PC, you may see ERROR 2503 followed by ERROR 2502: Fortunately there is both a fix and workaround for this problem: HOW TO FIX ERROR 2503 2502: Set the permissions on C:\WINDOWS\TEMP to AUTHENTICATED USERS = FULL CONTROL HOW TO WORK AROUND ERROR 2503 2502: End task on EXPLORER.EXE and start a new one WITH ADMIN PRIVILIGES.   You might also try running…

Handy Near Free PDF Tools I Need To Get My Job Done!

The following are six tools I use regularly to manipulate Adobe Acrobat .PDF’s: Quick PDF Tools – Free – Used to edit PDF document properties one by one.  They say it works on multiple files, but not for me. Batch PDF Pro – $40 and Batch PDF Watermark – Free – The free Watermark/stamp tool is included in the $40 Pro Version.  This sofware will split PDF’s into smaller .PDF’s based on number of pages,…

SOLVED: Cannot Paste Into OneNote 2016

If you can not PASTE content into OneNote, you are likely in VIEW ONLY mode.  If you have purchased OneNote or you have an Office 365 subscription that includes OneNote, you can confirm this is the problem by: Click the menu bars  (three horizontal lines in the top left corner). Click SETTINGS Click ABOUT confirm it shows LICENSE TYPE: VIEW ONLY If it does, you can quickly correct the problem by: Click the menu bars  (three…

SOLVED: How To Export PowerPoint Slides at 300DPI High Resolution

If you need to output your PowerPoint at high resolution you can change the TIFF export quality to 300DPI with a simply Registry modification. How To Set PowerPoint To Export High Res TIFFs: You do NOT need to close PowerPoint before you make this change. Open RegEdit.exe Expand HKEY_CURRENT_USER\Software\Microsoft\Office\<###>\PowerPoint\Options Select EDIT > NEW and click DWORD Value. Type ExportBitmapResolution and press ENTER Click on ExportBitmapResolution, then select EDIT > MODIFY In the Value data box, type 300, select Decimal,…

SOLVED: How To Remove Links From Excel That No Longer Exist

If, when you open and Excel workbook, you receive an UPDATE LINKS message but the linked source no longer exists, you have a problem.  You SHOULD be able to go to the DATA tab > EDIT LINKS button and choose DELETE LINK on the offender but that often does not work. After working on this for sometime and doing what I could to avoid downloading utilities to correct the problem, I gave up and downloaded…

SOLVED: Overtype / Insert Is Not Working in Word 2013

The short answer is, you are correct.   Microsoft has intentionally disabled that functionality in Word 2013.  In Excel 2013 the INSERT key still overtypes as you would expect. The long answer is, you can easily change it!  Click FILE > OPTIONS > ADVANCED and near the top you will see USE THE INSERT KEY TO CONTROL OVERTYPE MODE; put a check mark beside that.  The USE OVERTYPE MODE check box is like forcing the INSERT…

SOLVED: How to CALL Microsoft on the PHONE to Activate your Windows or Office Product

Below is the help file from a Windows Activation screen.  It contains all of the phone numbers Microsoft has worldwide for its activation centers: To activate your product over the telephone, use one of the following numbers: Windows activation: (888) 571-2048 Microsoft Office activation (United States only): (888) 652-2342 TTY number: (800) 718-1599 If you are an international customer, find the telephone number from the following list:   Country/region Volume License Keys only toll call…

SOLVED: How To Enable The POWER BUTTON in Windows 8.1 Update 1

This has taken me about a day to figure out!  I have a new Surface 3 that I have wiped out and imaged with a Win8.1 ISO sourced from the Volume License Service Center (with a release date of 4/13/2014, which I thought included Update 1).   After adding in updates KB2959977 and KB29330418 as per UPDATE 1 instructions which and rebooting I found that I most of the UPDATE 1 improvements (like a context menu when right…