View Full Version : Excel question: splitting data into multiple cells?
06-05-2005, 04:03 PM
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)?
06-05-2005, 04:37 PM
I found how to do it. I used the Text to Columns wizard from the Data menu
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.
vBulletin® v3.7.3, Copyright ©2000-2013, Jelsoft Enterprises Ltd.