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?