Extract only numbers and text generated by formulas and paste in new range

1. Press Shift+Ctrl+V to open the Paste Special dialog box.
2. From the option list, enable only the Text, Numbers and Click OK.

        This will gives only values not formula.

          Ref : http://blogs.sun.com/oootnt/entry/removing_duplicate_rows_in_calc