Translations:Basic Excel Trainer/112/en
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?