You go to Menu Bar : DATA -- TEXT TO COLUMN. This function helps you to
seperate two groups of data in a cell. By using this function, you can
determine what is the delimeter like space, comma or column.

According to your sample of data, the delimeter is space


Here is the instruction
1. Highlight the column of data you want to seperate
2. go to Data -- Text To Colum, it will prompt you the 3-step instruction
3. At first step, you select "Delimeted" radio button, then hit Next
4. At second step, you check box of SPACE. (as your data delimeter is SPACE)
5. Hit FINISH button.

But, you have to spare an empty column next to the column where your data is
as well because the second group of data will be seperated and placed in the
next column.

Hope this help.

ToMMie

"K****ij" wrote:

Hi,

Well I tried to seperate alphabets and numbers from a single cell but it has
to be done manually, the example of my data is "123456 klm" , "1294535 PTY",
"00000000018956 MO7 Payment Recived". I have almost 10000 enteries of such
data.

Thanks for your concern.

K****ij