Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto splitting of data in a cell
Good evening.
A have a board, copied from and html file, to an excel worksheat. The cells now contain numerical data, but in a form like this: "33,87% (14)". The 33,87% is the persentage of people who answered a question and the (14) is the number of people who answered that question. So, what i want is to automaticaly split this data in a different worksheat, without using the "text to columns" tool. The point is to copy and paste the unsorted and mixed data from the html file, and simply have columns with the data that are usefull for making charts etc. In my case, 33,87 in one cell, and 14 in another cell (without the simbols %, (, ) or a space). Hope you can help me. Best regars. Ioannis |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto splitting of data in a cell
If you have your value to split in A1 then enter this in B1
=LEFT(A1,FIND("%",A1)-1) and this in C1 =MID(A1,FIND("(",A1)+1,LEN(A1)-FIND("(",A1)-1) If you want these in another sheet then replace A1 with Sheet1!A1 everywhere (assuming that value is in A1 of Sheet1). You can copy the formula to parse multiple values. "Ioannis Syrakis" wrote: Good evening. A have a board, copied from and html file, to an excel worksheat. The cells now contain numerical data, but in a form like this: "33,87% (14)". The 33,87% is the persentage of people who answered a question and the (14) is the number of people who answered that question. So, what i want is to automaticaly split this data in a different worksheat, without using the "text to columns" tool. The point is to copy and paste the unsorted and mixed data from the html file, and simply have columns with the data that are usefull for making charts etc. In my case, 33,87 in one cell, and 14 in another cell (without the simbols %, (, ) or a space). Hope you can help me. Best regars. Ioannis |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Splitting Data in a Cell into Groups | New Users to Excel | |||
Splitting data in a cell | Excel Discussion (Misc queries) | |||
Splitting data out of a single cell | Excel Discussion (Misc queries) | |||
Splitting Cell Data | Excel Discussion (Misc queries) | |||
Splitting Data in a Cell | Excel Worksheet Functions |