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

Keeping client information safe in an age of scams and security threats

A look at the Dirty Dozen tax scams and ways to protect taxpayer information.

TAX PRACTICE CORNER

More R&D tax help

"Can I use the R&D credit?" PATH Act enhancements make the credit more attractive to a wider range of taxpayers.

QUIZ

News quiz: Tax-related data breach explained

News about a data breach that affected about 100,000 people, the IRS’s budget for the fiscal year, and the 2018 health spending account limits received attention recently. See how much you know with this short quiz.