• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

delete -between number

zeldy

New Member
i have arow with numbers -how do I delete the - that the number will be without - all the row
20321260-0​
20423117-9​
20152899-9​
20397909-1​
31251195-9​
20400725-6​
31252388-9​
30051871-9​
04065260-4​
31259823-8​
20092473-6​
31212950-5​
31252352-5​
30539111-2​
31251325-2​
03950567-2​
 
Select the cells you want to process
Ctrl+h on the keyboard
type a minus sign in Find what: field
nothing in the Replace with: field
other settings as shown:
77629
Click Replace All.
If these values are the result of formulae in those cells we'll have to do something else.
 
Back
Top