On Sun, 14 Sep 2008 05:08:00 -0700, Tazeem
wrote:

Dear, example of data is as under:

SABIC (KSA) 114.500
Kingdom Holding (KSA) 8.000 664 1 3.4 0.0
Etisalat (UAE) 1 6.700 2 ,026 2 7.2 -2.9

Regards,
Tazeem

You could download and install Longre's free morefunc.xll add-in from
http://xcell05.free.fr

Then use these formulas:

A1: your data string

B1: Initial text portion (ends with a <space followed by a digit or plus,
minus or dot)
=REGEX.MID($A1,"^.*?(?=\s[-+.\d])")

C1: First set of numbers:
=REGEX.MID($A1,"[-+]?\b\d*\.?\d+\b",COLUMNS($A:A))

Fill right as far as required to get all sets of numbers. (To I1 in your
example)
--ron