Excel question: splitting data into multiple cells?

Factual Questions
1

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)?

2

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

3

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.