Re: $$Excel-Macros$$ SOLVE THIS

Try =DATE("20"&RIGHT(A1,2),MID(A1,4,2),MID(A1,2,2)) It will convert the string as date On 2/27/15, Sam Mathai Chacko wrote: > =--TEXT(RIGHT(A1,6),"00\/00\/00") > On 27 Feb 2015 11:47, wrote: > >> I have a data like below where I need only date. >> >> S270215 >> R270215 >> >> -- >> Are you =EXP(

Re: $$Excel-Macros$$ SOLVE THIS

=--TEXT(RIGHT(A1,6),"00\/00\/00") On 27 Feb 2015 11:47, wrote: > I have a data like below where I need only date. > > S270215 > R270215 > > -- > 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://

$$Excel-Macros$$ SOLVE THIS

I have a data like below where I need only date. S270215 R270215 -- 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

$$Excel-Macros$$ Function for Data validataion

Dear experts, I want to formula for data validation to fulfill below conditions. 1. Total character should be 11 degit 2. Last 7 character should be numeric 3. First 4 character should be Alphabatic (A to Z) Please see attached file in which 3rd criteria I can't make it. P*Please do no

$$Excel-Macros$$ Re: Creating new sheet for each person and transferring their data

I am trying to do this exact same thing but within Google Sheets. need this same code structure but within Googles javascript format I assume. I don't think I can just take this excel script and use it correct? On Sunday, June 6, 2010 at 9:29:52 PM UTC-7, Amanda wrote: > > Hi all, > > I'm st

$$Excel-Macros$$ Re: Attaching or Linking Specific Outlook Email Into Cell

No takers ?? On Wednesday, 25 February 2015 11:41:47 UTC-5, Bill Q wrote: > > Hi, > > I can do this as an object - but quite frankly it is more hassle than what > it's worth. > > Does anyone have a better way (with minimal steps) where one can link or > embed a specific Outlook email into an e

Re: $$Excel-Macros$$ Please help me Urgent

Are you wanting a macro made to work like a function? Like: =CaseSwap(A1) where CaseSwap is: Option Explicit Public Function CaseSwap(target As String) Dim Pos As Integer Dim StrNew StrNew = "" For Pos = 1 To Len(target) If (Mid(target, Pos, 1) = UCase(Mid(target, Pos

Re: $$Excel-Macros$$ Please help me Urgent

Thanks Paul for your quick reply. Yes I was also trying to create a macro but Just wanted to confirm before, if that's possible in excel functions. No worries. I really appreciate your quick response once again. Thank you. Regards Gaurav Devrani On Thu, Feb 26, 2015 at 10:16 PM, Paul Schreiner

Re: $$Excel-Macros$$ Please help me Urgent

I don't believe you'll be able to do that with standard Excel functions. you can create a CUSTOM function using VBA and use it like an Excel function. In your case, you need to process each character and "switch" the case. the problem is, within a standard Excel function, there's no way to "proces

Re: $$Excel-Macros$$ Excel Tip

THANKS FOR GREAT TRICK VAIBHAV WORKING PERFECTLY On Thu, Feb 26, 2015 at 12:01 PM, amar takale wrote: > pls look sheet where sheetl1 not change as per you saying. Pls explain me > > On Thu, Feb 26, 2015 at 10:58 AM, Vaibhav Joshi wrote: > >> Dear Amar >> >> Data in col b date only, you just n

$$Excel-Macros$$ Please help me Urgent

Hi Guys, I have a query . In this sentence.. "This iS a tEst" . All Upper case alphabets should be lower case and All Lowercase alphabets should be in Upper case. Please help me . I want that to be done in excel formulas.(If thats possible). Thanks & Regards Gaurav Devrani -- Are you =EXP(E

Re: $$Excel-Macros$$ Re: mouseover on list of item in combobox

Welcome... :) On Thursday, February 26, 2015 at 2:25:08 PM UTC+5:30, Sal Sal wrote: > > no words! > this is exactly wath i need. > Tks for all. > > 2015-02-26 6:28 GMT+01:00 Vaibhav Joshi >: > >> This is superb MV >> >> Cheers!! >> >> On Wed, Feb 25, 2015 at 7:25 PM, michael vinoth > > wrote: >>

Re: $$Excel-Macros$$ Re: mouseover on list of item in combobox

Thankl You Vabz... :) On Thursday, February 26, 2015 at 10:59:17 AM UTC+5:30, Vabz wrote: > > This is superb MV > > Cheers!! > > On Wed, Feb 25, 2015 at 7:25 PM, michael vinoth > wrote: > >> Hi Sal Sal , >> >> Please find the attached updated macro file. >> >> Regards, >> MV >> >> On Wednesday, F

$$Excel-Macros$$ Give example

Give address examples plz -- 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 titles, like Please He

$$Excel-Macros$$ Re: Points distribution formula

Check this result with the help of helper column . in case you want the approximate match remove roundup function from formula and set vlookup to approximate match set it to 1. .\ Regards, Mandeep On Thursday, 26 February 2015 14:34:17 UTC+5:30, Deepak Rawat wrote: > > Hi, > > I have s

$$Excel-Macros$$ Points distribution formula

Hi, I have some target achievement data. I need to make a formula to which increase points as target achievement increases gradually. sheet is attached, It is little complicated for me to how to increase gradually by a formula automatically. regards, Deepak -- Are you =EXP(E:RT) or =NOT(EXP(

Re: $$Excel-Macros$$ Re: mouseover on list of item in combobox

no words! this is exactly wath i need. Tks for all. 2015-02-26 6:28 GMT+01:00 Vaibhav Joshi : > This is superb MV > > Cheers!! > > On Wed, Feb 25, 2015 at 7:25 PM, michael vinoth > wrote: > >> Hi Sal Sal , >> >> Please find the attached updated macro file. >> >> Regards, >> MV >> >> On Wednesday