# Excel question: splitting data into multiple cells?

**URL:** <https://boards.straightdope.com/t/excel-question-splitting-data-into-multiple-cells/307045>\
**Category:** Factual Questions\
**Created:** [June 5, 2005, 9:03pm UTC](https://boards.straightdope.com/t/excel-question-splitting-data-into-multiple-cells/307045 "2005-06-05T21:03:47Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dog80](https://avatars.discourse-cdn.com/v4/letter/d/6bbea6/32.png) [@Dog80](https://boards.straightdope.com/u/Dog80)\
**Post date:** [June 5, 2005, 9:03pm UTC](https://boards.straightdope.com/t/excel-question-splitting-data-into-multiple-cells/307045/1 "2005-06-05T21:03:47Z")

</div>

I have a single collumn with tire sizes, eg: 185/65R14. Is there any way to split that into three columns, eg: 185, 65 and 14 (I don’t want the R)?

---

<div class="post-metadata">

**Author:** ![Dog80](https://avatars.discourse-cdn.com/v4/letter/d/6bbea6/32.png) [@Dog80](https://boards.straightdope.com/u/Dog80)\
**Post date:** [June 5, 2005, 9:37pm UTC](https://boards.straightdope.com/t/excel-question-splitting-data-into-multiple-cells/307045/2 "2005-06-05T21:37:36Z")

</div>

I found how to do it. I used the Text to Columns wizard from the Data menu

---

<div class="post-metadata">

**Author:** ![Kewk](https://avatars.discourse-cdn.com/v4/letter/k/7ab992/32.png) [@Kewk](https://boards.straightdope.com/u/Kewk)\
**Post date:** [June 5, 2005, 9:43pm UTC](https://boards.straightdope.com/t/excel-question-splitting-data-into-multiple-cells/307045/3 "2005-06-05T21:43:41Z")

</div>

I assume that you have a long list of data. If not you can manually copy it number by number. If you do have a big data list you can do the following:

Copy that data to Microsoft Word (Not note pad or wordpad) hit ctrl+f then select the replace tab.

In “Find what” type in the symbol/letter you want to remove.  
In “Replace with” put a space.

Now save that file.

Open up excel and go to Data \> Import external data \> Import data.

Now in the “Files of type” box select "All Files (_._)).  
Navigate to where you saved the word file and select that.  
Select the amount of rows that you want it split into ( you can hit next to see if it split how you like).  
Hit finish and it should be done.