Really silly question but I don't want to go thru hundreds lines to delete the minus sign one by one. Thanks!!
Really silly question but I don't want to go thru hundreds lines to delete the minus sign one by one. Thanks!!
Did you try...
Find and Replace
- Ctrl + H (Opens Find and Replace dialogue box)
- Find what: -
- Replace with: (nothing)
- Replace All
- OK
HTH
Regards, Jeff
That's right.. forgot about the Replace function. Thanks!
You're welcome…glad you have a workable solution and thanks for the feedback...
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Thanks for the 'rep'
Another solution could be using the formula abs()
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks