Dear Tan,
Find “*” with suffix one or two character and replace only selected suffix
Like find “09*” and replace with “09”
Regards
LAKSHMAN
From: tan dennis
To: excel-macros@googlegroups.com
Sent: Friday, 9 December 2011 5:16 PM
Subject: $$Excel-Macros$$
Hi Tan
Try :
Sub Mtest()
Cells.replace What:="~*", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
End Sub
*special character must be precede by “~” when you use find & replace option
*
Formula : Assuming Date with special c
Just select the columns ( D & E ) desired and use
edit>replace ~* with (leave BLANK)
Don Guillett
SalesAid Software
dguille...@gmail.com
From: tan dennis
Sent: Friday, December 09, 2011 5:46 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ To remove the character "*
Dear Dennis,
SAM solution is great
You can also use below macro to select area where you want to remove *.
*Sub Remove_star()
Dim rng As Range
For Each rng In Selection
rng.Value = Application.WorksheetFunction.Substitute(rng, "*", "")
Next
End Sub
*
--
Thanks & regards,
Noorain Ansari
=SUBSTITUTE(D9,"*","")
or
=--SUBSTITUTE(D9,"*","") if you want to ensure it is equivalent to the date
value
Regards
Sam Mathai Chacko
On Fri, Dec 9, 2011 at 5:16 PM, tan dennis wrote:
>
>
> Hi All
> I have a spreadsheet with 4000 row of records, I need to remove the
> character "*" in cells w
