Auto splitting of data in a cell

[Ioannis Syrakis]

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

 

[Sheeloo]

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.