cros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Removal Special Charracter in Excel
You do not need a formula. Just select the cells button(upper left) and then
EDIT>REPLACE>
~*
WITH
NOTHING (LEAVE BLANK)
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Imran khan &l
Macros$$ Removal Special Charracter in Excel
Dear All,
Could you please help me to find correct formulla to remove charracter like (*
, /..). I have data in which having dates in 12-Feb-2011* format, in which
i need to remove *.
I have attached file for solution.
Regards,
Imran Khan
--
I think substitute is also working.
See the attached sheet.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shaik Waheed
Sent: Dec/Wed/2011 07:11
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Removal Special Charracter in Excel
Oh
m [mailto:excel-macros@googlegroups.com]
On Behalf Of Shaik Waheed
Sent: Dec/Wed/2011 06:57
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Removal Special Charracter in Excel
Hi,
You can simply use "Ctrl+H", in find place, type '*' and replace it with
blank, dats it.
O
Oh sorry dude this will not work out.
Formula is: =substitute(a1,"*","")
On Wed, Dec 28, 2011 at 6:57 PM, Shaik Waheed wrote:
> Hi,
> You can simply use "Ctrl+H", in find place, type '*' and replace it with
> blank, dats it.
>
> On Wed, Dec 28, 2011 at 3:58 PM, Imran khan wrote:
>
>> Dear Al
Hi,
You can simply use "Ctrl+H", in find place, type '*' and replace it with
blank, dats it.
On Wed, Dec 28, 2011 at 3:58 PM, Imran khan wrote:
> Dear All,
>
> Could you please help me to find correct formulla to remove charracter
> like (* , /..). I have data in which having dates in 12-Fe
Dear All,
Could you please help me to find correct formulla to remove charracter like
(* , /..). I have data in which having dates in 12-Feb-2011* format, in
which i need to remove *.
I have attached file for solution.
Regards,
Imran Khan
--
FORUM RULES (934+ members already BANNED for vio