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|0 Comments

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 [...]

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 [...]

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 [...]

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|0 Comments

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|0 Comments

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|0 Comments
Go to Top