Hello,
I have a set of data in one cell which I want to extract into their own columns.
An example of the data I have is here:
(row 1) Cats 546,6 9,8 % 110,0 31,3 %
(row 2) Cars and Airplanes 111,0 11,5 % 569,0 0,9 %
I want to extract the data from each cell into 5 separate columns like this: text, number, percentage number, number, percentage number (the percentage mark can be included).
The text might contain one or multiple words and "-" signs as well. Numbers and percentage marks will be presented in the same way always.
I guess this could be done by recognizing the first number of each set but I was unable to do it.
Appreciate your help!
Bookmarks