Re: $$Excel-Macros$$ unable to do any operation with this data

2011-10-26 Thread Sanjib Chatterjee
...@gmail.com *From:* Sanjib Chatterjee chatterjee.kolk...@gmail.com *Sent:* Tuesday, October 25, 2011 3:00 AM *To:* excel-macros excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ unable to do any operation with this data Dear Members, Please see the attachment. I am unable to do any

$$Excel-Macros$$ unable to do any operation with this data

2011-10-25 Thread Sanjib Chatterjee
Dear Members, Please see the attachment. I am unable to do any operation with this figure in the excel file. (i.e. Addition, multiplication, division etc) please help regards, Sanjib -- -- Some

Re: $$Excel-Macros$$ unable to do any operation with this data

2011-10-25 Thread Swapnil Palande
Hi, There are white spaces before number, remove those spaces and then you can use functions. Regards, Swapnil. On Tue, Oct 25, 2011 at 1:30 PM, Sanjib Chatterjee chatterjee.kolk...@gmail.com wrote: Dear Members, Please see the attachment. I am unable to do any operation with this

Re: $$Excel-Macros$$ unable to do any operation with this data

2011-10-25 Thread Sanjib Chatterjee
Dear Swapnil Palande, how to remove the space. What function do i use? PLease help ragards, sanjib On Tue, Oct 25, 2011 at 1:36 PM, Swapnil Palande palande.swapni...@gmail.com wrote: Hi, There are white spaces before number, remove those spaces and then you can use functions.

Re: $$Excel-Macros$$ unable to do any operation with this data

2011-10-25 Thread NOORAIN ANSARI
Dear Sanjeet, Please try below formula and see attached sheet. =TRIM(SUBSTITUTE(A2,CHAR(160),CHAR(32))) -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On

Re: $$Excel-Macros$$ unable to do any operation with this data

2011-10-25 Thread NOORAIN ANSARI
Dear Sanjib, Replaces each nonbreaking space character (Unicode value of 160) with a space character (ASCII value of 32) by using the SUBSTITUTE function, and then removes the leading and multiple embedded spaces from the string BD 122 (BD 112) -- Thanks regards, Noorain Ansari

Re: $$Excel-Macros$$ unable to do any operation with this data

2011-10-25 Thread dguillett1
) End If Next Application.ScreenUpdating = True End Sub Don Guillett SalesAid Software dguille...@gmail.com From: Sanjib Chatterjee Sent: Tuesday, October 25, 2011 3:00 AM To: excel-macros Subject: $$Excel-Macros$$ unable to do any operation with this data Dear Members, Please see

Re: $$Excel-Macros$$ unable to do any operation with this data

2011-10-25 Thread Sam Mathai Chacko
Guillett SalesAid Software dguille...@gmail.com *From:* Sanjib Chatterjee chatterjee.kolk...@gmail.com *Sent:* Tuesday, October 25, 2011 3:00 AM *To:* excel-macros excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ unable to do any operation with this data Dear Members, Please see