hello group,
How r all of u, I have a excel file in hindi has some name and add etc. I
have to translate them in english, can we do that plz tell me. file attahced
Anil
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles,
fyi
regards
jitendra singh
9015340017
On Fri, Jan 20, 2012 at 12:57 PM, PrIyAnKa p.dhamsa...@gmail.com wrote:
Dear Sunita
Kindly give one example of what u want in your sheet as to study the data
and analyse the same and preparing format as per your requirement takes a
lot time
So kindly
Dear Anil,
Attached file format is same as you posted previous. All Fonts are in Hindi.
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Fri, Jan 20, 2012
Hey thanks Priyanka, it workss perfectly the way I wanted to thanks alot :)
On Fri, Jan 20, 2012 at 12:20 PM, PrIyAnKa p.dhamsa...@gmail.com wrote:
Dear Mahreen
Kindly find the attached file and see the yellow highlighted row ,i have
did the same w/o pivot
On Thu, Jan 19, 2012 at 11:12
Its logical.
=IF(VALUE(RIGHT(INT(A2),1))0,INT(A2)+(10-VALUE(RIGHT(INT(A2),1))),INT(A2))
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shankar Bheema
Sent: Jan/Wed/2012 04:58
To: Paul Schreiner; excel-macros@googlegroups.com
Subject:
You are welcome
On Fri, Jan 20, 2012 at 2:23 PM, Mahreen Ellahi mahreen.acc...@gmail.comwrote:
Hey thanks Priyanka, it workss perfectly the way I wanted to thanks alot :)
On Fri, Jan 20, 2012 at 12:20 PM, PrIyAnKa p.dhamsa...@gmail.com wrote:
Dear Mahreen
Kindly find the attached file
Dear Sunita
Kindly find the attached file
Hope this is as per your req
2012/1/20 सुनिता पौडेल tosune...@gmail.com
Dear Priyanka,
Thank you for the interest shown. Please find attached the example of what
I required.
On Fri, Jan 20, 2012 at 1:12 PM, PrIyAnKa p.dhamsa...@gmail.com
Thank you very much for the prompt action. It works as per my requirement.
Have a wonderful day!
On Fri, Jan 20, 2012 at 2:56 PM, PrIyAnKa p.dhamsa...@gmail.com wrote:
Dear Sunita
Kindly find the attached file
Hope this is as per your req
2012/1/20 सुनिता पौडेल tosune...@gmail.com
Try this One:
Sub MyTest()
Dim wksSheet As Worksheet
Set wksSheet = ThisWorkbook.Worksheets(Sheet1)
Application.screenUpdating=False
With wksSheet
.Range(D2).Formula = =LEFT(A2,FIND(U,A2,1))
.Range(E2).Formula = =RIGHT(A2,LEN(A2)-LEN(D2))
I just use indirect function to get reference from another sheets, well we
can use this long formula also J
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ashish Bhalara
Sent: Jan/Thu/2012 09:22
To: excel-macros@googlegroups.com
Subject:
Dear Experts,
I want to take unique words from A1 cell.
please suggest
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
Dear Raghu,
I hope your requirement is this one..*
=(LEN(A1)-LEN(SUBSTITUTE(A1,gole,)))/LEN(B2)*
See attached sheet.
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/*
Dear Sourabh,
Please use this one to find unique value of more than one column without
using helping column
*=IF(SUMPRODUCT(($A$2:$A2=A2)*($B$2:$B2=B2))1,Duplicate,Unique)
*
See attached sheet.
On Fri, Jan 20, 2012 at 6:50 AM, Sourabh Salgotra rhtdmja...@gmail.comwrote:
Thank you so much sir,
Yes sir, this same file, How can i do plz tell me.
I have to translate that data in english
Anil
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need
Hi Noorain..
Its not static .. text can be change.. need a dynamic solution
Rajan
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of NOORAIN ANSARI
Sent: Jan/Fri/2012 03:39
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Required
Try this :
=REPLACE(REPLACE(A1,3,2,.),6,5,.)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Mohammed Muneer
Sent: Jan/Thu/2012 09:56
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ code
I want to change this column A to column G (means I
Do you want to translate data or just want to change format ??
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of anil kumar
Sent: Jan/Fri/2012 04:23
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ query about translate
Yes sir, this
Try this VBA Function :
Paste it in a VBA module and use
Function ExtractUnique(rng As Range) As String
Set rng = Range(a1)
Dim objDic As Object
Set objDic = CreateObject(Scripting.Dictionary)
For i = 1 To Len(rng.Value)
If Not
HI
Do you want to convert you data in xml?
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sushil Kumar
Sent: Jan/Thu/2012 02:00
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Copy data from excelsheet to html file
Hi,
Dear Neeraj,
Once again try through..
Control Panel-Folder Options then view.
It may be help to you.
On Fri, Jan 20, 2012 at 1:27 PM, Neeraj Chauhan
neerajchauhan...@gmail.comwrote:
Dear All,
** **
Kindly see the snap carefulle hiddin opetion is hidden. Why it not showing
and I
Try this one:
Sub isExist()
On Error Resume Next
If WorksheetFunction.Match(Range(rngValues).Value, Range(List), 0)
Then
If Err.Number = 1004 Then
Err.clear
On error goto 0:on Error Goto -1
MsgBox Values not found
Else
MsgBox Range(rngValues).Value
End
thanx noor
From: NOORAIN ANSARI noorain.ans...@gmail.com
To: excel-macros@googlegroups.com
Sent: Friday, 20 January 2012 11:20 AM
Subject: Re: $$Excel-Macros$$ EXCEL - TIPS
Dear Kishore,
You can study attached Ebook step by step..
It will help you to learn
I want to translate all name and add. in english
anil
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or
Try this:
Sub LoopingAllFileInAFolder()
Dim strPath As String
Dim fso As Scripting.FileSystemObject
Dim fldFolder As Folder
Dim flFile As File
Set fso = New Scripting.FileSystemObject
With Application
.FileDialog(msoFileDialogFolderPicker).Show
Dear Noorain
Anil want to do like under written
Jh yksds'k dqekj vxzoky to Shri Lokesh Kumar Aggarwal
From: NOORAIN ANSARI noorain.ans...@gmail.com
To: excel-macros@googlegroups.com
Sent: Friday, 20 January 2012 2:13 PM
Subject: Re:
Dear Darwin,
It is working fine on my system,
we can use below code in this format for dynamic path..
Sub savemethod()
Dim todaydate As String
Dim fileSaveName As String
Path = VBA.InputBox(Enter Path)
todaydate = VBA.Format(DateSerial(Year(Date), Month(Date), Day(Date)),
dd-mmm-)
I think no way in excel without use of any other software
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of anil kumar
Sent: Jan/Fri/2012 06:12
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ query about translate
I want to
use http://translate.google.co.in/
On Fri, Jan 20, 2012 at 6:26 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
I think no way in excel without use of any other software
** **
Rajan.
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf
go to run type cmd
@command prompt type
attrib -r -s -h -a filename
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick
many -2 thanks to all of u
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't
Hi Rajan,
I Don't want to convert the file; however i just want to input the data
from the sheet into the specific web site. here at my office some of my
team members work is to enter some data which is in excelsheet on the web
site.
Thank you in advance.
Sushil.
On Fri, Jan 20, 2012 at 5:35
Hi
It can be through excel.. which is that web site and how much data you have
to enter In online Form..??
Regards
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sushil Kumar
Sent: Jan/Fri/2012 07:50
To: excel-macros@googlegroups.com
Subject:
Dear All,
I have Date in A1 = 20-Jan-12, I want in B1 =mm/dd/yy hh:mm:ss AM/PM
format (1/20/2012 7:00:00 AM)
Please give me formula.
regards,
Imran
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Dear Imran,
Please use
=TEXT(A1,mm/dd/yy hh:mm:ss AM/PM)
On Fri, Jan 20, 2012 at 10:10 PM, Imran khan ikha...@gmail.com wrote:
Dear All,
I have Date in A1 = 20-Jan-12, I want in B1 =mm/dd/yy hh:mm:ss AM/PM
format (1/20/2012 7:00:00 AM)
Please give me formula.
regards,
Imran
--
FORUM
Hi Rajan,
We have one 5 to 6 fields like name, number, address and zip code etc...
and we have to add that data on client web site. can you please suggest the
VBA codes so that i can apply this on our excel sheet and modify as per the
requirement. due to client web site (process application) i
this are the temp files..not possible to UNHIDE but try to use *attrib -s
-h -r* in cmd
use:-
press window+r button for run then type cmd and then type atrib -s -h -r
then enter
On Fri, Jan 20, 2012 at 12:29 PM, Neeraj Chauhan neerajchauhan...@gmail.com
wrote:
Dear sir,
** **
Dear experts,
I want to change date format from 20120121 or 21012012 to 21-Jan-2012,
because excel not count as an date format if I replace - or / character
between date,month and year. Is there any function to convert this type of
number in proper date format? Because this type of date generate
Hi Ashish,
use this formula (if you date format is same 20120121 )
*=DATEVALUE(CONCATENATE(LEFT(B2,4),-,MID(B2,5,2),-,RIGHT(B2,2)))*
On Sat, Jan 21, 2012 at 9:50 AM, Ashish Bhalara
ashishbhalar...@gmail.comwrote:
Dear experts,
I want to change date format from 20120121 or 21012012 to
or try this one.. for any format
=TEXT(B2,-00-00)+0
On Sat, Jan 21, 2012 at 10:14 AM, xlstime xlst...@gmail.com wrote:
Hi Ashish,
use this formula (if you date format is same 20120121 )
*=DATEVALUE(CONCATENATE(LEFT(B2,4),-,MID(B2,5,2),-,RIGHT(B2,2)))*
On Sat, Jan 21, 2012 at 9:50
try this
=TEXT(TEXT(B3,-00-00),DD-MM-)
chandru
On Sat, Jan 21, 2012 at 10:16 AM, xlstime xlst...@gmail.com wrote:
or try this one.. for any format
=TEXT(B2,-00-00)+0
On Sat, Jan 21, 2012 at 10:14 AM, xlstime xlst...@gmail.com wrote:
Hi Ashish,
use this formula (if you
Dear Experts
I am attaching an excel form, in which according to the promotion date text
box the proportionate pay text box has to show in the command button event
the pay of that particular month according to the days calculation.
eg. if the pay is 1000/- pm (consider every calendar month
Dear All,
Can someone please explain how the below formula will work I mean what logic
it will follow.
Regards,
Amit Desai
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of NOORAIN ANSARI
Sent: 20 January 2012 16:22
To: excel-macros@googlegroups.com
Thanks a lot for formula, could you please explain the means of +0 in the
end of formula?
Thanks from Ashish.
On Sat, Jan 21, 2012 at 10:29 AM, chandra sekaran duraichan...@gmail.comwrote:
try this
=TEXT(TEXT(B3,-00-00),DD-MM-)
chandru
On Sat, Jan 21, 2012 at 10:16 AM, xlstime
for convert to number format ... u also use ''--'' befor formula like
=--TEXT(B2,-00-00)
On Sat, Jan 21, 2012 at 11:40 AM, Ashish Bhalara
ashishbhalar...@gmail.comwrote:
Thanks a lot for formula, could you please explain the means of +0 in
the end of formula?
Thanks from Ashish.
On
44 matches
Mail list logo