Replacing "*" in a cell

  • Thread starter Thread starter tinop
  • Start date Start date
T

tinop

Hi all,
Got a quick question,
I downloaded my bank statement in txt format. When there is a skip i
check number, the bank mark the next check number using "*". Example
chk 1011 1013*.
I want to get rid of the "*" using 'Replace' but Excel consider it a
'all' so excel replaces all of the value.
All I want to do is to change '1013*' to just '1013' without * so I ca
sort it by check number.
Anyone?
Thank you
 
On Wed, 19 May 2004 14:12:06 -0500, tinop


Use ~* and excel will treat it as a real *, but not "all".
 
Back
Top