INTHEBLACK February 2023 - Magazine - Page 66
WORK SMART
EXCEL TIPS
NEW EXCEL TEXT FUNCTIONS
A recent update to the subscription
version of Excel has added a set of
three text functions that make it much
easier to work with and extract text.
SUBSCRIBE
to the Excel Tips
podcast
Excel has always had several functions to allow
manipulation of text. The problem with the existing
text functions is that they need to be combined to
perform many common tasks. The new text functions
are built to extract text based on identifying special
text within text, called delimiters.
Read the full article
CPA Australia, INTHEBLACK – Neale Blackwood CPA
Excel Tips: New Excel text functions
CLICK TO LAUNCH VIDEO IN A NEW WINDOW
66 INTHEBLACK February 2023
Neale Blackwood CPA,
A4 Accounting
Send questions to
a4@iinet.net.au