Semua terjemahan
Masukkan sebuah nama pesan di bawah ini untuk menampilkan semua terjemahan yang tersedia.
Ditemukan satu terjemahan.
| Nama | Teks sekarang |
|---|---|
| r Inggris (en) | Proceed as follows: # Cut the existing column E, and paste it into column H:<br />[[File:S3 22.png|Text to columns(2)]] # Select the cells that need to be split (here, they are H3:H10). # From the 'Peralatan Data' section of the 'Data' tab of the Ribbon, click on 'Teks ke Kolom'. # Check the 'Dibatasi' option on the first step of the wizard, then click 'Berikutnya'.<br />[[File:S3 23.png|Text to columns(3)]] # We must now tell Excel what character/s should be used to split apart the cell contents. #* The preview area at the bottom of the dialog box shows the effects of the delimiter/s selected. #* We see that using a space alone will not work for all rows:<br />[[File:S3 24.png|Text to columns(4)]] #* However, using '(' as well as a space does split the numbers from the remainder of the cell entries:<br />[[File:S3 25.png|Text to columns(5)]] # Click 'Berikunya' to move to the final step of the wizard. # Each column in turn can be processed: #* The field can be retained, or skipped (not imported) #* The data category can be assigned. #* We choose to omit the 'Shed' field:<br />[[File:S3 26.png|Text to columns(6)]] #* Click 'Selesai' to finish. |