On Thu, 10 Sep 2009 06:11:02 -0700, Graham
wrote:

Hi I would like to separate the following text so the numbers are in separate
columns.

0.2 to 1.5 bar

Thanks

Graham

Are the numbers always as you show above?

In other words, are they always unsigned floating point numbers that will
always have an integer and a decimal portion?

If so, you could download and install Longre's free morefunc.xll add-in (Google
for a working source) and use this formula:

First Number: =REGEX.MID($A1,"\d+\.\d+",1)
Second Number: =REGEX.MID($A1,"\d+\.\d+",2)

If there were more numbers, just increment the last argument.

If the numbers might be formatted differently, post back.

The formula returns the values as a text string. If you require them to be
numeric, then precede the function with a double unary:

=--REGEX.MID($A1,"\d+\.\d+",1)

--ron