Let's assume your text is in A1 and let's also assume that the number is
always followed by a space.

=VALUE(LEFT(A1,SEARCH(" ",A1)-1))
--
HTH,
Barb Reinhardt



"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?