Forum Discussion
from Function results to "real" numbers to calculate
That's since within your texts are non-printable characters with unicodes 8236 and 8237, that's usual story with copy/pasting data from web. You may check substituting above characters on something visible like
You may try to play with Paste special; or replace UNICHAR(8236) and UNICHAR(827) (add such formulas to empty cells, copy value, Ctrl+H and replace it everywhere on nothing); or play with your formulas to extract numbers without non-printable characters if they are always on same positions. Something like this. Not sure I found all non-printable characters, perhaps more of them are here.
Or use Power Query to pick-up data from web and transform.
SergeiBaklan
I have found the solution. because every combination has an unique lenght I combined the functions have serveral times with =IF and =LENGHT now it's working without problems. thanks for your suggestion, it was helpfull to keep looking and trying different things.
Thanks,
Hugo
Hugo, you are welcome