Hi everyone and thank you in advance or your help!
I have an issue with some cells which contain numbers and symbols. My goal is to separate them in new cells and these two cells to have a number format. I am referring at "number format" because when I tried to use the left formula to keep some certain numbers, the new cell had a text format. Anyway.
In order to give you a sample... As you can see, the numbers before the two symbols %€ are indefinite. Some times is one character, some other times are two, some other have space in the start... And we have the same problem and with the numbers after the two symbols %€.
I can't find any motive, a way, to separate with formula (I don't want the Data----> Text to columns solution) and keep in different cells (with number format!) the numbers before the %€ symbols and the number after the %€ symbols.
A and B columns is what I have now and C,D,E,F columns is what I want to have as a solution with the formula/function.
Many thanks to anyone who will help me
I have an issue with some cells which contain numbers and symbols. My goal is to separate them in new cells and these two cells to have a number format. I am referring at "number format" because when I tried to use the left formula to keep some certain numbers, the new cell had a text format. Anyway.
In order to give you a sample... As you can see, the numbers before the two symbols %€ are indefinite. Some times is one character, some other times are two, some other have space in the start... And we have the same problem and with the numbers after the two symbols %€.
A | B | C | D | E | F |
20 %€ 46 | 80 %€ 185 | 20 | 46 | 80 | 185 |
8 %€ 15 | 92 %€ 175 | 8 | 15 | 92 | 175 |
79 %€ 110 | 21 %€ 29 | 79 | 110 | 21 | 29 |
98 %€ 198 | 2 %€ 3 | 98 | 198 | 2 | 3 |
23 %€ 58 | 77 %€ 197 | 23 | 58 | 77 | 197 |
3 %€ 8 | 97 %€ 233 | 3 | 8 | 97 | 233 |
19 %€ 254 | 75 %€ 1,826 | 19 | 254 | 75 | 1826 |
25 %€ 623 | 75 %€ 1,826 | 25 | 623 | 75 | 1826 |
1 %€ 2 | 99 %€ 200 | 1 | 2 | 99 | 200 |
0 %€ 20000 | 100 %€ 1,317 | 0 | 20000 | 100 | 1317 |
7 %€ 601 | 93 %€ 70,498 | 7 | 601 | 93 | 70498 |
43 %€ 317 | 57 %€ 426 | 43 | 317 | 57 | 426 |
96 %€ 3,922 | 4 %€ 170 | 96 | 3922 | 4 | 170 |
95 %€ 4,199 | 5 %€ 241 | 95 | 4199 | 5 | 241 |
83 %€ 179 | 17 %€ 35 | 83 | 179 | 17 | 35 |
4 %€ 18 | 96 %€ 439 | 4 | 18 | 96 | 439 |
0 %€ 2 | 95 %€ 441 | 0 | 2 | 95 | 441 |
I can't find any motive, a way, to separate with formula (I don't want the Data----> Text to columns solution) and keep in different cells (with number format!) the numbers before the %€ symbols and the number after the %€ symbols.
A and B columns is what I have now and C,D,E,F columns is what I want to have as a solution with the formula/function.
Many thanks to anyone who will help me