I have a formula, that extracts a number from a cell (like bla bla Pris: xxx.00):

MID(A3:A2000,FIND("Pris: ",A3:A2000)+6,FIND(".00",A3:A2000)-FIND("Pris: ",A3:A2000)-6)

The result is correctly xxx

But xxx can't be calculated on in other cells.