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.
Advertisement
TOPICS
Information management and technology assurance
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.
The power of a digital detox and the value of committee volunteering
The first installment of a three-episode podcast road trip features an in-person discussion with a CPA who has learned to prioritize unplugging while on vacation. Listen to the episode or read the Q&A with Iowa’s Carrie Kruse, CPA, CGMA.
Features
SPONSORED REPORT
How to find the right CAS clients
The key to success with CAS is selecting the best clients. Tools like ideal client profiles (ICPs), buyer personas, and even artificial intelligence can help identify the businesses that best fit each CAS practice.
From The Tax Adviser
March 6, 2026
Navigating the Form 1099-DA reporting maze
February 28, 2026
CPA firm M&A tax issues
February 18, 2026
Why LIFO, why now?
February 10, 2026
