An item in the July 2003
issue and the December
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
function by clicking on Data