<div>
If it is a .CSV file, you can delineate the columns when you first open the file. &nbsp;That is how I would do it.
</div>


M--Personal-ee---Text-to-Columns---.xlsx

<div>
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.<br />
<br />
I have recommended this question be closed as follows:<br />
<br />
Split: <br />
-- DanCh99 (<a href="https:#a41784611" rel="ugc">https:#a41784611</a>)<br />
-- ProfessorJimJam (<a href="https:#a41783265" rel="ugc">https:#a41783265</a>)<br />
<br />
<br />
If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.<br />
<br />
frankhelk<br />
Experts-Exchange Cleanup Volunteer
</div>


<div>
<div class="content wysiwyg-content">
each row has the following format<br />
<br />
Healthcare, Cancer Care, Pregnancy and Childbirth, Weight Loss, Primary Care, Heart and Lung Care, Back and Spine Care, Orthopedics<br />
<br />
<br />
I want to separate each word into its own cell. how to do this?<br />
<br />
i have 2k rows like this
</div>
</div>


each row has the following format

Healthcare, Cancer Care, Pregnancy and Childbirth, Weight Loss, Primary Care, Heart and Lung Care, Back and Spine Care, Orthopedics


I want to separate each word into its own cell. how to do this?

i have 2k rows like this

separate comma separated lists

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.