Hi, In a worksheet the cell contains the a text as well as number. i want the text in one cell & Number in one cell.

Example:

It is given as Month08 or (Month08year09)

I want it as Month in one cell & 08 in one cell. (i.e Month / 08)

Thanks,

Sandhya

I'm assuming your using Excel? Try this:

If Cell A1 contains Month08

In Cell B1 to get Month enter the formula: =LEFT(A1,5)

In Cell C1 to get 08 enter the formula: =RIGHT(A1,2)If Cell A1 contains Month08year09

In Cell B1 to get Month enter the formula: =LEFT(A1,5)

In Cell C1 to get 08 enter the formula: =MID(A1,6,2)Also you Excel questions will get a better response if you post them in the Office Software forum.

MIKE

Hi Mike, Its a Great Solution.,

I Got the answer. Thank U So Much.

Regards,

Sandhya

Ask Your Question

Weekly Poll

Would you ride in a self-driving car from Tesla?

Discuss in The Lounge

Poll History