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