Wiki Sumber Informasi iSIKHNAS

Step4

• The final step is to remove the ' Week' from all of the UsaiMinggu data (D2:D543).
• Using Autofilter, we see that the entries are very consistent - all have a number, a space, then 'Week'.
• This means that we can use either of two techniques to make the changes required:
  • 'Teks ke Kolom'
  • 'Temukan dan Ganti'
• Having completed this step - you are done! However, make sure to take the time to apply an autofilter, and check the data in each field.
  • Is it necessary to format this dataset in any way? Why or why not?