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 .

 

SPONSORED REPORT

The technology assessment engagement

Are you working with the best technology? Do you know how to help your clients determine if their technology stack measures up? In this free report, J. Carlton Collins, CPA, explains how to answer those questions via a technology assessment engagement.

FEATURE

Maximizing the higher education tax credits

A counterintuitive strategy can save taxes by including otherwise excludable scholarships in gross income.