How-to
How to Split Text in Excel With TEXTSPLIT (Names, Lists, Delimiters)
Use Excel's TEXTSPLIT formula to split names and lists into columns or rows, including on several delimiters at once.
· 4 min
Tech, figured out.
Clear how-to guides, plain explanations and sourced news on the software, devices and cars you use.
Just in
Gemini 4 Hydrogen Replaces 3.8 Flash: Who Gets It and What It CostsApache 2.4.71 Fixes Critical HTTP/2 RCE: How to Check If You're ExposedNintendo Ends Google and Apple Sign-In on Jan 26, 2027: What ChangesGoogle Fi Brings Back Network Switching With a 'Secondary' PartnerNotion AI Chats Exposed in Fireworks AI Breach: Check Your WorkspaceAndroid Auto Now Requires Android 11: Is Your Phone Cut Off?Outlook.com Reportedly Bouncing Email From Domains Without DMARCAndroid XR Glasses Pre-Orders Open Nov 12: What's Confirmed So FarFox Now Owns Roku: What Changes on Your TV and What Fox Promised
Pick up where you left off
How-to guides
Do the thing, step by step.
80 articles →
Explainers
Finally understand how it works.
54 articles →
Buying guides
What to buy, and what to skip.
49 articles →
News
What changed, with the sources.
65 articles →
Guides worth keeping
Useful today, still useful next year.
Buying guide
How to Choose an M.2 SSD for PS5: Check Heatsink Height Before Speed
· 6 min
How-to
How to Use VLOOKUP in Excel: Syntax, Examples and Error Fixes
· 3 min
How-to
How to Convert Text to Numbers in Excel (Green Triangle, VALUE, and Paste-Back)
· 3 min
How-to
How to Use FILTER in Excel With Two Conditions and a No-Match Message
· 3 min
How-to
How to Fit an Excel Sheet on One Page When Printing (and Keep It Readable)
· 5 min
How-to
How to Create an Excel PivotTable (and Fix Fields That Count, Not Sum)
· 2 min
Explainer
Your Drive Shows Less Storage Than Advertised? Start With Apple's Explanation
· 2 min
How-to
How to Use SUMIFS in Excel to Add Values That Meet Several Conditions
· 3 min
How-to
How to Use COUNTIF in Google Sheets to Count Cells That Match
· 2 min
Explainer
Moving an eSIM From Android to iPhone: When You May Need Your Carrier
· 2 min
What just happened
All news →
Pick a topic
All topics →
Fresh on AnIntent
How-toHow to Create a Drop-Down List in Excel With Data Validation
Add a drop-down list to an Excel cell with Data Validation, keep the header out of the choices, and fix a greyed-out Data Validation button.
How-toHow to Use XLOOKUP in Excel to Find a Value in Another Column
Write a basic Excel XLOOKUP formula and check whether your Excel version supports the function.
How-toCloud & Productivity Software
How to Use Flash Fill in Excel (Ctrl+E) to Split or Join Names
Use Excel's Flash Fill (Ctrl+E) to split or combine names, turn it on if it won't preview, and switch to formulas when your data changes.
Buying guideHow to Choose Matter Smart-Home Devices Without Guessing
What to check before buying Matter smart-home devices: your ecosystem, the connection type, and what the CSA's Matter 1.4 announcement covers.
ExplainerHome Networking
Should 2.4 GHz and 5 GHz Wi-Fi Share One Name? What Apple Says
Apple recommends one Wi-Fi name for every band. Here is why, and what 2.4, 5 and 6 GHz each trade between range and speed.
How-toCloud & Productivity Software
How to Freeze Rows and Columns in Excel (Pick the Right Cell First)
Freeze header rows and columns in Excel on Windows, Mac, iPad and iPhone, pick the right cell first, and fix a grayed-out Freeze Panes button on a Mac.
ExplainerPrivacy & Security
Where to Check Whether a Factory Reset Erases Your Phone
Which official pages to read, and which questions to answer, before you rely on a factory reset to wipe a phone you plan to sell.
How-toHow to Add a Table of Contents in Google Docs Using Heading Styles
Insert a table of contents in Google Docs, pick a dotted-line or linked style, and set up the headings it is built from.
Buying guideBuying Guides
How to Choose a NAS Hard Drive: Check CMR vs SMR Before You Buy
Why CMR vs SMR matters for a NAS, how to check a drive's recording method before you buy, and what to look at after that.
How-toHow to Share Google Calendar From Android and Pick the Right Permission
Share a Google Calendar with one person from Android, choose between the five permission levels, and fix an invite that never arrived.
Buying guideHow to Read a Monitor's DisplayHDR Label Before You Buy
Which DisplayHDR tier names VESA lists for monitors, why True Black is a separate spec, and what to check on a spec sheet before buying.
How-toSoftware
How to Show File Extensions in Windows 11 (and Spot a Fake .pdf.exe)
Turn on file name extensions in Windows 11 File Explorer two ways, rename an extension without breaking a file, and read names like invoice.pdf.exe.
We show our work, so you can check it.
1
Researched live
Written with AI from pages read on the web that day, not from memory.
2
Every claim linked
Sources sit next to the facts they support, one click away.
3
Checked before publishing
Links and claims are tested automatically. Failures do not go live.