ICAEW.com works better with JavaScript enabled.

Tech News

View the latest community announcements and articles from Tech News. Providing links to information, guidance, events and Tech Faculty expertise.

Access the archive

Latest Articles

Excel Community round up - April 2021

Here are all the new Excel articles and webinars from the Excel Community in April 2021. Posts marked as public can be accessed by anyone; other articles are accessible to Excel Community & Tech Faculty subscribers and can be accessed by logging in to your ICAEW account.

Excel Tip of the Week #392 - Text to Columns redux

Hello all and welcome back to the Excel Tip of the Week. This week we have a Creator level post in which we’re taking a definitive revisit to the handy data transformation tool, Text to Columns. This was last covered back in TOTW #105

Splitting columns to make reporting easier

When working with data from text files it is often necessary to split a single column into multiple columns, or even rows. For example, an account code might encompass several components such as account type, department and detailed analysis and, to allow the data to be summarised by each of these components, it will be necessary to separate each of them into their own columns.