Excel question: splitting data into multiple cells?

[Dog80]

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

[Dog80]

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

[Kewk]

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.