Search results

Wants to convert this text " One thousand and twelve" to 1012.

I have written multiple command in excel in column. how do i run on command prompt?

I have tried sumproduct formula but there is some mistake.. Please guide me.

(remove duplicate and count)

Hello Friends, Need small help from your side. I have value 9 in cell A1, now i need 9 zeros in Cell from B1 to Z1. I'll have to change the value in A column and it is maximum till 25. So i no need to use more columns after column Z. If i write 5 in A2 then the result would be in B2 to F2 = 0...

Hello Friends, I have checked the below given link http://chandoo.org/forum/threads/how-convert-number-to-text-in-excel.12009/ I get the nearest result. But actually i wants to teach my boy. I don't want "Rupees only" or"Paisa" at last.. and If Possible I would also like to convert Spell to...

=IF(C2 = T., 0,1):( name error. Can anyone please guide me?

How to protect only the author name in excel 2007? I don't want to protect another things in sheet. Please guide me Thanks you all.

Hello Friends, Need your help for sum with multiple criteria. It is difficult to describe here. So i have uploaded here excel file.. Thank you all.

Stuck with too many formula. Not get an idea how the get the result. http://rapidshare.com/files/2467620047/SUMIF%20LEFT%20RIGHT%20with%20Name%20criteria.xlsx

How to rename 0112021317_007_T.jpg to 0112021317_007_F.png? In details: I have file name list in excel. I want to rename the file names. left sided 15 characters stays as it is but rename only last 5 digits. Help me please..

How to convert 020713 in 2/Jul/13 ?

Have tried had to get the result but not get yet. Please guide me what's wrong in my formula. Please check below given link for file. http://rapidshare.com/files/1513561679/Monthly%20report.xlsx

In a column, there are many dates. I want to count it month wise. For example in column A: 24-Jan-13 24-Jan-13 31-Jan-13 31-Jan-13 7-Feb-13 7-Feb-13 14-Feb-13 14-Feb-13 want to count how many dates are from January, feb... Please guide me.

Did excel provide this facility in excel 2008 mac?

A column has file name. B column has to be folder path. For example: I have one folder, in it there are too many folder and it has files too in it. if i find as *.* in folder then i can get the all file name list, but how can i get the path details in excel? Please help me.

I want to import multiple xml files in to one sheet. A2 has to be file name(xml file name), B2 has to be date of file creation and time, C2 has to be folder name only(from which folder it was import) and D2 to G2 has to be the data from xml file. Each xml has 4 lines written in it and it is...

I have created small calendar, Column A has dates, Column B has days, Column C has Weeks If i type 1 in cell E4, then F4 to F10 should haves dates from week 1 and G4 to G10 should have days(monday,tues,wed..) Please help for these formulas. For reference i have uploaded here file...

There is figure 245, it means 4 hours and 5 minutes. if i am dividing the 245 with 60 then result is 4.08. But actual i want 4:05. Help me please. Which formula or format can do. Thanks

I have thousands of .xml files. i want to import all in excel rowwise with file name. i tried to import but i m not able to add multiple files.. Can anybody help me please..

Want to add multiple xml file in excel. Is there a way to import all xml files in individual cell as A1, A2, A3... ActiveWorkbook.XmlImport URL:= _ "C:UserslaxmanbDesktopBrijxml1_SMF35980413.xml", ImportMap:=Nothing, _ Overwrite:=True, Destination:=Range("$A$1") Range("A2").Select...

As in Indian calender, there are many festivals and leaves like.. 14th Jan - Kite flying day 15th Jan - Makarsankrati. 26th Jan - Republic Day. 14th Feb - Valentine day. etc.. Need your help for formula. Thank you.

Hello Friends, once again Happy New Year to all. I need your help .. I have just prepared one calender. I am making school attendance register. explaining here details. A column = Roll No, B Column = Student Names, Month-January in C2, C3 to AR3 weekdays. Su-Mo-Tu-We to Sa, C4 to AR4...

I have name list. like.. paragatulbhaishah parthatulbhaishah dhruvatulbhaishah There is no space between name, middle name and surname. now i want to search how much son of atulbhai? and names of them. Please guide/help me.

I have prepared a sheet in IBM(windows), when i open it in mac.. It is not supporting.. There is simple countifs formula.. the result is #value..:( Anyone can please help me for this.. Why this happen?