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
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 ikha...@gmail.com wrote:
Dear All,
Could you please help me to find correct formulla to remove charracter
like (* , /..). I have data in which having
Oh sorry dude this will not work out.
Formula is: =substitute(a1,*,)
On Wed, Dec 28, 2011 at 6:57 PM, Shaik Waheed waheedb...@gmail.com 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
]
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.
On Wed, Dec 28, 2011 at 3:58 PM, Imran khan ikha
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
$$ 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
--
FORUM
@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
EDITREPLACE
~*
WITH
NOTHING (LEAVE BLANK)
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Imran khan mailto:ikha