...@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
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
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
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.
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
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
)
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
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