Loading...

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:00 May 11th, 2021|Computers, Documentation, Excel, Microsoft|0 Comments

How to block callers

Yealink T46 & T48 Navigate to Menu > Directory > Blocklist Tap the Add softkey or tap the Add button (touchscreen) Using the keypad, enter a Name for the Blocklisted contact Press the down arrow on the directional keypad or tap the Office Number field (touchscreen) Enter the phone number to blocklist Tap Save When a contact number is [...]

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:00 May 18th, 2020|Computers, Documentation, Email, Microsoft, Outlook|0 Comments

How do I use Password Manager on the Client Portal?

How do I use Password Manager on the Client Portal? Please login to the Client Portal (How do I logon to the Client Portal?) Once you have logged on, you can click the Password Manager (note: not Change Password) option under the Hello, (your name)! (or for some accounts it just reads "Hello!") at the [...]

How do I add my email account to my Android tablet or smart phone?

How do I add my email account to my Android tablet or smart phone? The steps vary quite a bit across various differing Android devices, and software versions, but the basics are: Touch the Settings icon Select Account Touch Add Account Select Personal (IMAP) When prompted for email or user and password, enter your full [...]

Telephone: Request Directory Listing

Our Directory Listing service allows you to submit a phone number for listing in several national directory listing databases.  Many directory assistance providers use these national databases for their listing information.  Most national databases will pick up the information within 6 to 8 weeks. Numbers must have completed porting before you may request a directory [...]