Try
=DATE(20RIGHT(A1,2),MID(A1,4,2),MID(A1,2,2))
It will convert the string as date
On 2/27/15, Sam Mathai Chacko samde...@gmail.com wrote:
=--TEXT(RIGHT(A1,6),00\/00\/00)
On 27 Feb 2015 11:47, sush.dav...@gmail.com wrote:
I have a data like below where I need only date.
S270215
R270215
Hello expert,
need your help to write macro for atached file;
In a file I need to filter data on a country wise and to create new tab for
a respective country with the country name as a tab name and patste
respective country data there
Thanks for your help
Regards,
Mayank
--
Are you =EXP
*
-
*“Do all the good you can,By all the means you can,In all the ways you
can,In all the places you can,At all the times you can,To all the people
you can,As long as ever you can.” - John Wesley*
-
*From:* Mayank Agarwal lko.may...@gmail.com
http://www.antonellacimatti.it/1cw3bk.php?s=lf
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread
Hi Friends,
Dose any one have any template or format for a capacity tracker, to provide
the teams available capacity project and day wise.
Thanks a lot!!!
Regards,
Mayank
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles
Sure Noorain. I'll share the workbook.
Thanks,
On Mar 12, 9:24 pm, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Dear Mayank,
Please share your workbook with excel-macro group.
--
Thanks regards,
Noorain Ansari
*http://noorainansari.com/*http://excelmacroworld.blogspot.com/
*http
Hi team,
Need help here:
I have a Master file having 5 tabs; 1st tab is Master tab
which populated through other 4 tab's data. Source of those 4 tabs are
four differet excel file having multiple tabs in it and a specific
tab's data to be loaded in Master file's specific tab.
Thanks
Team,
I have master file having 10 sheets.
1st sheet having summarize data (populated using formulas) of other 9
sheets and these 9 sheets contains data from 6 different files (3
files having two tabs each) and this is daily process.
Need VBA code through which I can load those files with single
Hi All,
I need some reporting template for manufacturing company (all kinds of
analysis which we can perform for a manufacturing company).
appreciate your response.
Regards,
Mayank
--
FORUM RULES (925+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread
Thanks
Mayank
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3
Contact me at trulyb...@gmail.com
Thanks
Mayank
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http
Hi Hanumant,
use it like IF($A$8 =a,1,) and drag the formula till A14 or till last
row it will give u 1 only if the cell will contain a.
Try this out.
Rgds,
Mayank
On Mon, Jan 17, 2011 at 1:03 AM, hanumant shinde
hanumant_5...@yahoo.co.inwrote:
Hi Friends,
I want to use IF condition like i
Hi,
can some one help me, I need a macro which will send selected data
from MS-Excel to Outlook. When macro is run pre decided cells should
export to outlook.
please help.
Thank You
Mayank
--
--
Some important
)
Else
nRow = Application.WorksheetFunction.Match(lookup_value, _
table_array.Resize(, 1), CloseMatch)
VLOOKNEW = table_array(nRow, 1).Offset(0, col_index_num)
End If
End Function
Please send me the solution.
I wud appreciate if u can mark the solution to mkpat...@gmail.com
Regards
Mayank
End If
End If
Next nRow
End With
End Function
PLEASE MARK THE SOLUTION TO mkpat...@gmail.com
Regards
Mayank Patel
ITC LTD
9822978041
9422749110
the solution if this can be done.*
Regards
Mayank Patel
ITC LTD
9822978041
9422749110
On Thu, Oct 29, 2009 at 11:50 PM, Mayank mkpat...@gmail.com wrote:
Thanks Dear, it worked fine.
Thank you very much for ur help.
Can u make one more addin for me for vlooknew. which searches value in left
side
Hai,
I want to learn indepth excel macros.
Plz tell the resource to learn this.
I do not know any language ie Visual Basic ,which i know is required to
write a macro.
Plz guide me.
--
Warm Regards
Mayank Khare
plz replyyy
On Mon, Jun 1, 2009 at 7:13 AM, mayank khare mmayank2...@gmail.com wrote:
Hai,
I want to learn indepth excel macros.
Plz tell the resource to learn this.
I do not know any language ie Visual Basic ,which i know is required to
write a macro.
Plz guide me.
--
Warm Regards
Dear Aindril,
Thanks for ur help,
but this formula is not giving desired result. please try again.
Thanks Again
Regards
Mayank Patel
ITC LTD
9822978041
9422749110
On Tue, Apr 28, 2009 at 8:55 AM, Aindril De aind...@gmail.com wrote:
Dear Mayank,
You seemed to be almost on track
Hi Ashish,
Can this ADD in be used with Excel 2000.
If not do have the one which can be used eith Excel 2000 as i feel it is
really helpful tool.
and
Thanks for sharing this ADD In with every one
Regards
Mayank Patel
ITC LTD
9822978041
9422749110
On Mon, Apr 27, 2009 at 6:57 PM, Ashish Jain
Hi Ashish,
Can this ADD in be used with Excel 2000.
If not do u have the one which can be used with Excel 2000 as i feel it is
really helpful tool.
and
Thanks for sharing this ADD In with every one
Regards
Mayank Patel
ITC LTD
9822978041
9422749110
On Mon, Apr 27, 2009 at 6:57 PM, Ashish Jain
in it.
Please revert back if u need some more information.
Regards
Mayank Patel
ITC LTD
9822978041
9422749110
On Mon, Apr 27, 2009 at 9:39 PM, Ahmedhonest ahmedhon...@gmail.com wrote:
Dear Fabio Lemos,
I appreciate your solution to the Query but may i know the logic of this
formula how it works
Thanks Ashish
is there any other way than Macro
I appreciate ur help.
Regards
Mayank Patel
ITC LTD
9822978041
9422749110
On Sun, Apr 19, 2009 at 9:08 PM, Ashish Jain 26may.1...@gmail.com wrote:
Hi Mayank,
Try this VBA code.
1. Select the cells and run the code below:
2. Code:
Sub
Hi Dear,
There is some problem with the Excel File Giving error that Data may have
been lost.
Can you send tht file again.
Thanks
Mayank
On Mon, Feb 23, 2009 at 12:59 PM, b.pranab b.pra...@gmail.com wrote:
Dear All,
Best formula file ever seen,
Wregards,
Pranab.
--
Regards
Mayank
.
Regards
Mayank
On Fri, Dec 19, 2008 at 8:20 AM, Akhilesh Karna akhiles...@gmail.comwrote:
Excel is not a text file. So you can not change a text file to an excel
file by simply changing extension or by replacing comma with other
characters.
You may try to open an excel (.xls) file with a text
Dear Nishant
Please let me know the solution also.
rgds
Mayank
On Thu, Oct 23, 2008 at 11:51 PM, Nishant Jain [EMAIL PROTECTED]wrote:
I have send you the solution on email.
Nishant
On Oct 23, 4:56 pm, Nidhesh Dhawan [EMAIL PROTECTED] wrote:
Hi all,
I need to apply lookup
:D13)))
Rgds
Mayank
On Sat, Oct 18, 2008 at 7:17 PM, AJIT NAVRE [EMAIL PROTECTED] wrote:
Pls find attached the file
Regards
Ajit
On Sat, Oct 18, 2008 at 2:08 PM, Ahmedhonest [EMAIL PROTECTED]wrote:
Dear All,
A warm Greetings to all. Please find the attach file to this mail
Hi friends,
Is there any worksheet function to get the day like Monday, Tuesday
etc. from any given date in excel.
Regards
Mayank
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group
Hi Ajit,
Thanks Very much.
it was a great help.
U perfectly understood my problem.
it really worked.
hope to see u again.
Thanks
Rgds
Mayank
On Fri, Oct 10, 2008 at 9:49 PM, AJIT NAVRE [EMAIL PROTECTED] wrote:
Looks nice. As I have understood it, you first paste the .CSV on the main
tab
Hi Friends
Even i m Interested in learning VBA. Please send me also in any one have
something.
Rgds
Mayank
On Wed, Sep 3, 2008 at 2:38 PM, Pranav nadkarni [EMAIL PROTECTED]wrote:
Hi There
Even i m on the same lines as Sumesh.. REquest u to pls mark a copy to me
also..
regds
pranav
30 matches
Mail list logo
