TEXTSPLIT is a very useful function for breaking down text cells that contain different lengths of text and delimiters.
Advertisement
TOPICS
Information management and technology assurance
Using Excel’s TEXTBEFORE AND TEXTAFTER functions to easily tame messy data
Excel’s TEXTBEFORE and TEXTAFTER functions allow users to quickly split up text in ways that used to require combinations of functions like LEFT, RIGHT, MID, and FIND, leading to some confusing formulas.
Reputation, security, compliance: Why AI risk disclosures are surging
Nearly three-quarters of S&P 500 companies have disclosed at least one AI-related risk in Form 10-K filings so far in 2025. Learn what types of companies are reporting risk and what exactly they’re disclosing.
AICPA releases gen AI tool: Josi
A new generative AI tool, initially focused on the auditing and accounting space, accesses information within the AICPA Online Professional Library.
Reflecting on AI’s rise in accounting, looking to what comes next
A consultant and keynote speaker shares how AI, hybrid work, and uncertainty are reshaping the accounting profession. Ahead of his sessions at the Digital CPA Conference, Pascal Finette assesses the profession’s willingness to change.
AI, succession, the talent pipeline, and defining ‘unapologetic’ ambition
A profession leader and former AICPA chair shares what’s top of mind for corporate boards and looks ahead to topics of conferences in November and December. Listen to the podcast episode or read the Q&A with Kimberly Ellison-Taylor, CPA/CITP, CGMA.
AI-driven spreadsheet tools — what CPAs need to know
Emerging AI-enabled, automated data management tools such as Paradigm have the potential to challenge Excel’s current market dominance.
Car talk: M&A, AI and EVs changing the dealership landscape
Two speakers with vast industry knowledge preview their session at the AICPA Dealership Conference. Listen to the episode or read the Q&A.
Is spending on technology spinning out of control?
Information technology spending, driven by AI investment, is consistently rising, but a survey finds that most leaders assume that they’re spending more than other companies are.
Using 3 Excel View tools to manage large spreadsheets
This month’s column shows how you can use Microsoft Excel’s View features to more easily
navigate big datasets.
Building a better firm: How to pick the proper technology
Automation and other technologies are essential for business model modernization. Experts offer tips on choosing the right tech.
AI-powered hacking in accounting: ‘No one is safe’
Artificial intelligence is producing scary good cyberattacks, but CPAs can take steps to lower their risk of being a victim.
How BI and analytics enhance management accountants’ partnering role
Business intelligence and analytics tools are no longer optional to deliver real-time insights and support agile business decisions.
‘We’re still the thinkers’ — a reminder for tax pros in the AI era
Tax expert Annette Nellen highlights several tax provisions in the new budget law and why that law will be the main topic of conversation at the AICPA & CIMA National Tax Conference in November. Listen to the podcast episode or read the Q&A.
Incorporating prompt engineering into the accounting curriculum
It is imperative that accountants learn how to write effective instructions for generative AI applications like ChatGPT.
Create a dynamic to-do list with Excel’s checkboxes
Checkboxes can help you create interactive to-do lists and other types of lists that track progress.
Another way to manage authentication texts
Q. How can I manage multifactor authentication for text messages when I don’t want my staff to rely on my mobile device or use theirs? A. The most common method of multifactor authentication (MFA) involves using a text message. However, I don’t want the text message sent to my phone in case
2025 tax software survey
CPAs rate their return preparation software’s performance during this year’s tax season.
Take a bold leap instead of a tentative step
A profession leader discusses remote work, AI’s role in accounting, and how journaling and summer breaks help her stay grounded. Listen to the podcast episode or read the Q&A.
Calculating AI’s impact on CPAs: New study quantifies time savings
Researchers determine the real difference that generative AI can have on the average accountant in terms of time spent on routine data entry versus time available for client support and billable hours.
Features
FROM THIS MONTH'S ISSUE
Real-life ways small firms use AI
Learn how four small firms use artificial intelligence to automate processes while maintaining strong oversight.
From The Tax Adviser
July 31, 2026
Current developments in S corporations
July 31, 2026
