MartyMcFly
New member
Hi there, Can someone help me please ?
how do i extract a number if it has a text before it and a full stop after .... for example, the cell says "Money Out (£) 8.46." All i want is the numerical value of "8.46", please let me know, thanks in advance !
It could be to extract the number from the cell to a new cell or to replace the cell with just the number ? anyway is okay as i can move the value over afterwards
how do i extract a number if it has a text before it and a full stop after .... for example, the cell says "Money Out (£) 8.46." All i want is the numerical value of "8.46", please let me know, thanks in advance !
It could be to extract the number from the cell to a new cell or to replace the cell with just the number ? anyway is okay as i can move the value over afterwards