https://wiki.isikhnas.com/index.php?action=history&feed=atom&title=Translations%3ABasic_Excel%2F192%2Fen 2026-09-06T02:23:29Z Revision history for this page on the wiki MediaWiki 1.31.16 https://wiki.isikhnas.com/index.php?title=Translations:Basic_Excel/192/en&diff=8963&oldid=prev 2014-08-25T04:22:26Z

<p>Importing a new version from external source</p> <p><b>Halaman baru</b></p><div>Proceed as follows:<br /> # Cut the existing column E, and paste it into column H:&lt;br /&gt;[[File:S3 22.png|Text to columns(2)]]<br /> # Select the cells that need to be split (here, they are H3:H10).<br /> # From the 'Peralatan Data' section of the 'Data' tab of the Ribbon, click on 'Teks ke Kolom'.<br /> # Check the 'Dibatasi' option on the first step of the wizard, then click 'Berikutnya'.&lt;br /&gt;[[File:S3 23.png|Text to columns(3)]]<br /> # We must now tell Excel what character/s should be used to split apart the cell contents.<br /> #* The preview area at the bottom of the dialog box shows the effects of the delimiter/s selected.<br /> #* We see that using a space alone will not work for all rows:&lt;br /&gt;[[File:S3 24.png|Text to columns(4)]]<br /> #* However, using '(' as well as a space does split the numbers from the remainder of the cell entries:&lt;br /&gt;[[File:S3 25.png|Text to columns(5)]]<br /> # Click 'Berikunya' to move to the final step of the wizard.<br /> # Each column in turn can be processed:<br /> #* The field can be retained, or skipped (not imported)<br /> #* The data category can be assigned.<br /> #* We choose to omit the 'Shed' field:&lt;br /&gt;[[File:S3 26.png|Text to columns(6)]]<br /> #* Click 'Selesai' to finish.</div>

FuzzyBot