Which number are you look to get? It look like tyhe character portion of
theh string can be removed easily by using the closing parethesis. The
number can then be seperated by using text to columns and using delimiter -
Space as the seperator.

A1 = "Kingdom Holding (KSA) 8.000 664 1 3.4 0.0"

This formula will extract the company name into B1

Cell B1 =Left(A1,find(")",A1)-1)


This will extract the number portion
Cell C1 =mid(A1,find(")",A1)+1,len(B1))

You can remove the formula from the number portion by
Copy then Paste Special - Values

Once you have the number portion in a cell then you can use Text - to -
columns method using Delimited - space to put each number in its own column.




"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

"Joel" wrote:

Supply some example of your data and how you want to seperate these items.
Text to column May work if you choose the delimted option, then hit next and
selected spaces.

"Tazeem" wrote:

How exactly text and numbers can be separated in an unmerged cell. There is
not a fixed number of digits in the available data so 'Text to column' option
does not work. Please help.

Thanks & Regards