Truncating cells
=REPLACE(A1,FIND(" ",A1),255,"")+0
"Simon" wrote:
I have a column of cells formatted as text containing a number and text i.e:
123.123 text text text
I need some way of truncating the cell to only show the number for
calculation purposes. Any Ideas?
|