Wiki Sumber Informasi iSIKHNAS

Text to columns

The 'Teks ke Kolom' feature can be used when more than one type of information is stored within a single cell. In our example below, we want to extract the number of birds that are in each shed, and the shed number. Cell E3 contains '2200 (Shed 1)'; we need the numbers 2200 and 1, each in its own cell. Using an automatic way to do this means that it can be done quickly and accurately.