Hi Practice Practice,
Open the file in Excel. You will find all the information
autofit the data
Select all and then Use Text To Columns Feature in Excel.
Choose the Delimited option. And the the Next Screen you will have a place
to type a customized delimiter.
Type the Pipe symbol in that and clic
Dear Ramesh,
no i can able to derive the formula
can u send me excel file with same result
Sudhir
On Mon, Aug 9, 2010 at 8:18 PM, Ramkesh Maurya wrote:
> Dear Sudhir,
>
> Write =SpellNumber(cell) and press Enter
>
> I am sure u will get result
>
> On Mon, Aug 9, 2010 at 11:37 AM, NOORAIN ANSAR
Dear Nikhil,
Use *left *function
left(a1,3)
Regards
Sudhir Ingale
On Sun, Aug 8, 2010 at 2:48 PM, Nikhil Shah wrote:
> Hi Friends,
>
> I have written In Column " A " ...January ...
>
> Now I want in Column " B " should be ..Jan ...only...I want formula
