Excel: Convert text to numbers

Excel 2016 or newer =TEXTJOIN("",TRUE,IFERROR((MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1)*1),"")) Then copy that column to a new column - selecting values only Then note the error/note talking about numbers stored as text, and fix that.   REF: https://trumpexcel.com/extract-numbers-from-string-excel/#Extract-Numbers-from-String-in-Excel-Formula-for-Excel-2016

By |2021-05-11T13:29:31+00:00May 11th, 2021|Computers, Documentation, Excel, Microsoft|Comments Off on Excel: Convert text to numbers

How do I remove an email account from Microsoft Outlook?

Before performing these steps, please be certain you do not need to first do a backup of the email account contents currently available to you in Outlook. Removing an account from Microsoft Oultook is irreversible, and any content you have downloaded in that email account will be PERMANENTLY deleted. Please contact us for assistance if [...]

By |2020-05-18T17:15:32+00:00May 18th, 2020|Computers, Documentation, Email, Microsoft, Outlook|Comments Off on How do I remove an email account from Microsoft Outlook?

Why is my Windows 10 Computer so Slow?

While there are dozens of reasons your computer can be slowing down, here are some of our favorite initial checks: Check Disk Space Empty Recycle Bin Empty C:\Windows\Temp Empty C:\Windows\Software Distribution\Downloads Command Prompt (as Admin) DISM.exe /Online /Cleanup-image /Restorehealth DISM.exe /Online /Cleanup-Image /RestoreHealth /Source:C:RepairSourceWindows /LimitAccess sfc /scannow Disable non-essential Services Disable 'Superfetch' service Disable all [...]

By |2020-01-19T20:24:35+00:00November 23rd, 2018|Computers, Documentation, Microsoft, Windows, Windows 10|Comments Off on Why is my Windows 10 Computer so Slow?

Windows 10: Disable Ads

How do I disable Ads in Windows 10? Can you disable the Ads in the Windows 10 Start Menu? How To:  Start, settings, personalization, Start, Occasionally show suggestions in Start: OFF Start, settings, personalization, Lock screen: - Background: anything BUT Windows Spotlight. - Get fun facts, tips and more... : Uncheck Start Menu, right click the [...]

By |2017-12-01T23:47:24+00:00March 17th, 2017|Computers, Documentation, Microsoft, Windows, Windows 10|Comments Off on Windows 10: Disable Ads

Disable Windows Defender

How do I disable Windows Defender? Every time I turn it off, it comes back on by itself. You can disable Windows Defender either by using Group Policy or the Windows Registry. Group Policy gpedit.msc Computer Configuration > Administrative Templates > Windows Components > Windows Defender On the right: Turn off Windows Defender Select Enabled Windows [...]

By |2016-11-17T23:00:43+00:00November 17th, 2016|Computers, Documentation, Microsoft, Windows|Comments Off on Disable Windows Defender

Outlook for Mac 2016: Profiles

How can we view the profiles in Outlook 2016 for Mac ? Open the Applications folder Right-click Microsoft Outlook, Show Package Contents In the Contents folder open Shared Support Run Outlook Profile Manager   KEYWORDS Outlook Macintosh OSX Profiles REF https://support.office.com/en-us/article/Manage-profiles-in-Outlook-2016-for-Mac-fed2a955-74df-4a24-bef6-78a426958c4c  

By |2016-11-03T19:16:53+00:00November 3rd, 2016|Apple, Computers, Documentation, Mac, Microsoft, Outlook|Comments Off on Outlook for Mac 2016: Profiles

Windows Update stuck at “Checking for updates”

Troubleshooting Windows Updates can be a frustrating issue many times. The steps outlined in this article http://answers.microsoft.com/en-us/windows/forum/windows_10-update/windows-update-stuck-at-checking-for-updates/b79ecc03-5534-42fb-8847-43d2c8d98b94?linkId=16543816&Ocid=1.+Owned+NA+(Reactive)_Social_TWITTER_WindowsSupport_20150825_227327310&auth=1) (PDF: Windows Update stuck at %22Checking for updates%22 - Microsoft Community) have helped us quite a bit from time to time.   Notes: net stop wuauserv cd %systemroot%\SoftwareDistribution ren Download Download.old net start wuauserv   Windows Clean Boot

By |2016-08-02T14:06:16+00:00August 2nd, 2016|Computers, Documentation, Microsoft, Windows|Comments Off on Windows Update stuck at “Checking for updates”

Windows Clean Boot

Many times you will want to boot Microsoft Windows in a 'clean mode' where no additional drivers are loaded, etc... Of course, there is also Safe Mode for this, but Safe Mode is a bit more severe, and sometimes, you just need a cleaner/simpler boot, and not necessarily full on safe mode. See attached PDF, [...]

By |2016-08-02T13:27:55+00:00August 2nd, 2016|Computers, Documentation, Microsoft, Windows|Comments Off on Windows Clean Boot

Command line access to Serial Number and Model Info

Is there a way to access the Serial Number or Model Number of  a PC from the command line? Is there a way to access the Serial Number or Model Number of a PC remotely?   Yes - via the WMIC command. Yes - by remote controlling the PC, and using the WMIC command at [...]

By |2016-01-16T23:54:11+00:00January 14th, 2016|Computers, Documentation, Microsoft, MS-DOS / Batch, Windows|Comments Off on Command line access to Serial Number and Model Info
Go to Top