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

Hope this helps.

Pete

On Apr 30, 10:38*am, Deba Prakash Mohanty <Deba Prakash
wrote:
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:
Mobile: +91-9999 6848 91