24 November 2007

How to delete "-" from all cell ?

If you want to quick delete "-" out from all cell , you should be do?

Please follow me step by step

1.Coppy B3:B9











2.Paste on D:3

3.Select area D3:D8









4.Click manu Edit and select replace or Ctrl+H

5.Input "-" in block Find what:

6.Not input anything in block Replace

7.Click buttom Replace All

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.