Re: $$Excel-Macros$$ I can’t understand why I m unable to do sum

Dear Haseeb I am surprised of your wonderful command "Alt+0160 in Find What box: and click Replace All " can you brief that what is the meaning of 0160 with Alt command & is there further more commands available in excel. Regards, Aamir Shahzad On Wed, Dec 7, 2011 at 10:54 PM, Haseeb Avarakkan

Re: $$Excel-Macros$$ I can’t understand why I m unable to do sum

Dear Lakshman, You can also use simple... First Select Range Goto Data>Text to Column>Delemated>Remove Space>Enter Then you can use SUM Function - Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.c

Re: $$Excel-Macros$$ I can’t understand why I m unable to do sum

Also, select col_E press Ctrl+H to activate Find/Replace, from the keyboard NUMERIC side (right side of the keyboard, not the top row) Press Alt+0160 in Find What box: and click Replace All. Now you can do a simple SUM. Or use this Array Formula, =SUM(IFERROR(--SUBSTITUTE(E2:E18,CHAR(160),""),

Re: $$Excel-Macros$$ I can’t understand why I m unable to do sum

hi please use this Array Function with Shift+Ctrl+Enter ={SUM(VALUE(LEFT(E2:E18,LEN(E2:E18)-1)))} On Wed, Dec 7, 2011 at 2:45 PM, Maries wrote: > > Hi Lakshman, > > Please use the below codes: > > Sub Right_Delete() > ' This module will delete text from Right in selected cells. > Dim MyCell

Re: $$Excel-Macros$$ I can’t understand why I m unable to do sum

Thanks to all with the help of all of U, I understand the main problem. From: Maries To: excel-macros@googlegroups.com Sent: Wednesday, 7 December 2011 2:45 PM Subject: Re: $$Excel-Macros$$ I can’t understand why I m unable to do sum Hi Lakshman, Please

Re: $$Excel-Macros$$ I can’t understand why I m unable to do sum

thanks to all From: NOORAIN ANSARI To: excel-macros@googlegroups.com Sent: Wednesday, 7 December 2011 3:08 PM Subject: Re: $$Excel-Macros$$ I can’t understand why I m unable to do sum Dear Lakshman, Please try it and see attached Sheet.. Sub Remove_Space

Re: $$Excel-Macros$$ I can’t understand why I m unable to do sum

Dear Lakshman, Please try it and see attached Sheet.. Sub Remove_Space() Application.ScreenUpdating = False On Error Resume Next For Each C In Selection If Trim(Len(C)) > 0 And C.HasFormula = False Then C.NumberFormat = "General" C.Value = CDbl(C) End If Next Application.Scree

Re: $$Excel-Macros$$ I can’t understand why I m unable to do sum

Hi Lakshman, Please use the below codes: Sub Right_Delete() ' This module will delete text from Right in selected cells. Dim MyCell As Range Dim Total_Chars As Integer On Error Resume Next Total_Chars = 2 For Each MyCell In Selection.Cells If Len(My

Re: $$Excel-Macros$$ I can’t understand why I m unable to do sum

Sorry NOT USING TRIM On Wed, Dec 7, 2011 at 2:39 PM, Aindril De wrote: > NOTE: > I am using the simple TRIM(<>) function as the data you have sent contains > multiple spaces in the trail. > > > On Wed, Dec 7, 2011 at 2:35 PM, Aindril De wrote: > >> Dear Lakshman, >> >> You are not able to do th

Re: $$Excel-Macros$$ I can’t understand why I m unable to do sum

NOTE: I am using the simple TRIM(<>) function as the data you have sent contains multiple spaces in the trail. On Wed, Dec 7, 2011 at 2:35 PM, Aindril De wrote: > Dear Lakshman, > > You are not able to do the SUM as the data in the last column has leading > and trailing spaces. > You can use the

Re: $$Excel-Macros$$ I can’t understand why I m unable to do sum

Dear Lakshman, You are not able to do the SUM as the data in the last column has leading and trailing spaces. You can use the add-on http://www.ablebits.com/excel-trim-spaces/index.php to quickly remove the spaces, if you regularly receive/generate such data. Cheers, Andy On Wed, Dec 7, 2011 at

$$Excel-Macros$$ I can’t understand why I m unable to do sum

Dear All, Plz see the attach file. I can’t understand why I m unable to do sum. What is the problem in sheet or number? Help anybody? Regards LAKSHMAN -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgen