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?

Remote Desktop Copy and Paste not working

Q. Copy and paste between my RDP session and my local desktop is not working.     A. There are settings within each configured RDP connection to allow for copy and paste between the RDP session and the local desktop client, but sometimes this just doesn't take. If this is the case, the next fix [...]

By |2020-05-11T12:21:17+00:00November 4th, 2019|Computers, Documentation, Remote Desktop|Comments Off on Remote Desktop Copy and Paste not working

How do I reset my Mac, MacBook, MacBook Pro, etc?

There are a couple of steps to reset some of the underlying power controllers and firmware on a Mac Computer. This has become even more important to know now that batteries are internal and non-removable. - MacBooks with a non-removable battery Shut down your Mac. On your built-in keyboard, press and hold all of these [...]

By |2020-01-19T20:13:25+00:00July 3rd, 2019|Apple, Computers, Documentation, Mac|Comments Off on How do I reset my Mac, MacBook, MacBook Pro, etc?

How do I use Remote Desktop to connect to our Hosted Server?

How do I use Remote Desktop to connect to our anySiteSolutions Hosted Server? Microsoft Windows Click on the Start Menu and search for Remote Desktop Connection In the Computer text field, enter the server name provided by your technician. Select Show Options In the User name field, enter the username provided by your technician. Check [...]

By |2020-06-23T18:32:34+00:00April 15th, 2019|anySiteSolutions.com, Cloud, Computers, Documentation, Remote Desktop|Comments Off on How do I use Remote Desktop to connect to our Hosted Server?

How do I quit an app on my iPhone, iPad, or iPod Touch?

Q. How do I quit an app on my iPhone, iPad, or iPod Touch?     A. No Home Button On an iPhone X or later, or an iPad with iOS 12 or later, or iPadOS, from the Home screen, swipe up from the bottom of the screen and pause slightly in the middle of the screen. [...]

By |2020-03-29T13:33:32+00:00April 3rd, 2019|Apple, Cell Phone, Documentation, iOS, iPad, iPhone|Comments Off on How do I quit an app on my iPhone, iPad, or iPod Touch?

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?

How do I configure a Remote VPN connection to my network?

We have a fully managed network with anySiteSolutions.com, and need to remotely connect to the network while offsite, is this possible? Yes! Some benefits of this type of connection: You are essentially remotely putting your computer back inside your office walls and behind your secure firewall. Secure browsing from a public location, by routing all [...]

By |2020-04-06T14:08:18+00:00July 17th, 2018|anySiteSolutions.com, Computers, Documentation, Network, Networking, VPN|Comments Off on How do I configure a Remote VPN connection to my network?
Go to Top