extracting data from a cell

[Deba Prakash Mohanty]

Hi Sir
I want to extract some data from a cell.

For example, If A1 cell contains (1 Deba Prakash Mohanty), then I want to
extract 1 in one cell(B1), Deba in another cell(C1), Prakash in aonther
cell(D1), and Mohanty in another cell(E1).

Thanks and Regards,

Deba Prakash Mohanty
Email: (e-mail address removed)
Mobile: +91-9999 6848 91

 

[Mike H]

Hi,

Selevt the data then

data|Text to colums
Select delimited
Next
Check Space
Click Finish

Mike

 

[Pete_UK]

Highlight the column of data and then click on Data | Text-to-Columns,
using space as the delimiter.

Hope this helps.

Pete