Separate Data Inside An Excel Cell

BY STANLEY ZAROWIN

An item in the July 2003 issue and the December 2003 issue described various ways to separate multiple elements of data (such as Mickey Gray Mouse or 12 45 66 ) in a single Excel cell and distribute them into multiple cells. Several readers suggested another approach. David W. Scheuermann, a CPA from Metairie, Louisiana, was the first to e-mail me with this alternative: Evoke the Convert Text to Columns function by clicking on Data .

 

Where to find July’s flipbook issue

The Journal of Accountancy is now completely digital. 

 

 

 

SPONSORED REPORT

Better decision-making with data analytics

Data analytics has become a hot topic, but many organizations have not yet managed to understand its potential, let alone put it to work. This report will take a deep-dive on how to best introduce or enhance the use of data in decision-making.