Re: $$Excel-Macros$$ REPLACE

use this: =TRIM(LEFT(A5,27) & " " & RIGHT(A5,4) & " " & MID(A5,28,14)) *Pankaj Sharma * *MIS Analyst* *Greater Kailash-1, New Delhi* *Email * *p ankaj123...@gmail.com * *Skype** pankaj.sharma_pj* On Wed, Dec 23, 2015 at 12:24 PM, Vinod

Re: $$Excel-Macros$$ Replace cell value "0" to header cell

Please elaborate your query and send a sample file, if possible. On Mon, Sep 21, 2015 at 9:12 AM, Pramod Singh wrote: > Hi Expert. > > Q. (*Pramod Bisht) > Need to get:- (Pramod Bisht) > > By Text formula... > > Pramod > On 19 Sep 2015 17:54, "nyree" wrote: > >> Hello Abhishek >> >> That's pe

Re: $$Excel-Macros$$ Replace cell value "0" to header cell

Hi Expert. Q. (*Pramod Bisht) Need to get:- (Pramod Bisht) By Text formula... Pramod On 19 Sep 2015 17:54, "nyree" wrote: > Hello Abhishek > > That's pefect! Thank you so much for your quick response > Regards > Nyree > > > On 19-Sep-15 2:20 PM, Abhishek Jain wrote: > > Please see attached > >

Re: $$Excel-Macros$$ Replace cell value "0" to header cell

Hello Abhishek That's pefect! Thank you so much for your quick response Regards Nyree On 19-Sep-15 2:20 PM, Abhishek Jain wrote: Please see attached HTH, Abhishek On Sat, Sep 19, 2015 at 5:31 PM, N .williams > wrote: Hello I would like to know if it

Re: $$Excel-Macros$$ Replace cell value "0" to header cell

Please see attached HTH, Abhishek On Sat, Sep 19, 2015 at 5:31 PM, N .williams wrote: > Hello > I would like to know if its possible to use a macro or forumula to replace > every "0" with the header cell value and list each one by student > eg Student B: Q107, Q108, Q110 > > Many thanks for yo

Re: $$Excel-Macros$$ replace error with zero

Use formula iferror... Syntex is iferror(yourformula,0) Cheers!! On Tue, Jul 1, 2014 at 12:46 PM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > Dear Sir / Madam, > > Please see the attachment. I am facing a problem which i highlighted in > the excel sheets with yellow color. > Is

Re: $$Excel-Macros$$ Replace formulas with values

> *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Mukesh Kumar > *Sent:* Saturday, January 18, 2014 4:48 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Replace formulas with values > > > > Thanks R

Re: $$Excel-Macros$$ Replace formulas with values

Thanks Ravi for your help. This sheet fulfills my motive to some extent. But it will not work in following example : *A1=40% ; B2=200 ; C1=100 ; D1=A1*B1+C1. D1 will return 180 and i want to show th caclculation as "=40%*200+100* I have searched many forum regarding this & following link has so

Re: $$Excel-Macros$$ Replace formulas with values

Ashish ji, this code is working on column C only not on column E which also contains formula. As I have said earlier that user form is required which asks for range of cells first where to apply macro? Any help in this regards will be helpful to me. On Sat, Jan 18, 2014 at 12:50 PM, ashish koul

Re: $$Excel-Macros$$ Replace formulas with values

Sub test() Dim i As Long For i = 2 To Range("a65356").End(xlUp).Row Range("c" & i).ClearContents Range("c" & i).Formula = "=" & Range("a" & i).Value & "*" & Range("b" & i).Value Next End Sub On Sat, Jan 18, 2014 at 12:24 PM, Mukesh Kumar wrote: > Hi Experts, > > I need your help. My requir

Re: $$Excel-Macros$$ Replace data from another sheets by adding raw

* > > *Regards * > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Ashish Bhalara > *Sent:* 30 June 2012 9:21 > *To:* excel-macros@googlegroups.com >

RE: $$Excel-Macros$$ Replace data from another sheets by adding raw

homework Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ashish Bhalara Sent: 30 June 2012 9:21 To: excel-macros@googlegroups.com Subject: Re: $$Excel

Re: $$Excel-Macros$$ Replace data from another sheets by adding raw

Dear experts, Please suggest what should I do in that case, waiting for reply. On Fri, Jun 29, 2012 at 7:23 PM, Ashish Bhalara wrote: > > > On Fri, Jun 29, 2012 at 7:20 PM, Ashish Bhalara > wrote: > >> Dear experts, >> >> I need a function or macro to replace data from another sheets by >> addi

Re: $$Excel-Macros$$ Replace data from another sheets by adding raw

On Fri, Jun 29, 2012 at 7:20 PM, Ashish Bhalara wrote: > Dear experts, > > I need a function or macro to replace data from another sheets by addition > of raw, these addition of raw is depend on the record of another sheet. you > can find attached sheet for better understanding. I can do it manual

RE: $$Excel-Macros$$ Replace letters with numbers

=CODE(UPPER(A1))-64 A1 contains your letter Rajan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Maries Sent: Mar/Mon/2012 01:46 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Replace letters with numbers Hi, Try it

RE: $$Excel-Macros$$ Replace letters with numbers

=CODE(UPPER(A1))-64 A1 contains your letter Rajan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Maries Sent: Mar/Mon/2012 01:46 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Replace letters with numbers Hi, Try it

Re: $$Excel-Macros$$ Replace letters with numbers

Hi, Also try below code for your quary, Sub numeric() Dim MyCell As Range For Each MyCell In Selection.Cells MyCell.Value = Asc(UCase(MyCell)) - 64 Next End Sub Code On Mon, Mar 19, 2012 at 12:15 PM, Maries wrote: > Hi, > > Try it, > > > =CONCATENATE(IF(LEN(A1)>=1,CO

Re: $$Excel-Macros$$ Replace letters with numbers

Hi, Try it, =CONCATENATE(IF(LEN(A1)>=1,CODE(LEFT(A1,1))-64,""),IF(LEN(A1)>=2,CODE(MID(A1,2,1))-64,""),IF(LEN(A1)>=3,CODE(MID(A1,3,1))-64,""),IF(LEN(A1)>=4,CODE(MID(A1,4,1))-64,""),IF(LEN(A1)>=5,CODE(MID(A1,5,1))-64,""),IF(LEN(A1)>=6,CODE(MID(A1,6,1))-64,""),IF(LEN(A1)>=7,CODE(MID(A1,7,1))-64,""),

Re: $$Excel-Macros$$ Replace

Hi Shashank Find the attachment. Regards Thamu On Tue, Jan 18, 2011 at 12:10 PM, shashank bhosle < catchshashankbho...@yahoo.co.in> wrote: > HI All > > I want to replace some content that are in formula. > > Thanks and Regards > Shashank > > -- > > ---

Re: $$Excel-Macros$$ replace code changes blanks cells

But it's not a formula in the cell. Blank cell code loops through sees if it has a "-" and if it doesn't it moves to the next. If it does, the data in that cell is 18 digits before the removal of the "-", and 17 after. The code does not modify the cell at all if there is no "-" -- -

RE: $$Excel-Macros$$ replace code changes blanks cells

Hi, If you have a formula in a cell, it is never considered blank, even if the formula returns an apparent blank. You will often get this with 'IF' formulas: eg IF(A20=5,"Bing","") If A20 does not equal 5, then the formula returns a "". But XL sees this as a zero-length string, not a blank ce

Re: $$Excel-Macros$$ Replace contents in a formula used for whole sheet.

Dear Deshpande, I think a smart use of Ctrl + H (Find & Replace) will do the task here. Try identifying unique item to be replaced in entire worksheet(s) and just go ahead. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo