=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 tanbh...@yahoo.com wrote:
Hi All
I have a spreadsheet with 4000 row of records, I need to remove the
character * in
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
Just select the columns ( D E ) desired and use
editreplace ~* 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 *
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 char
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 tanbh...@yahoo.com
To: excel-macros@googlegroups.com
Sent: Friday, 9 December 2011 5:16 PM