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