Hi Moms, Ladies, Mbak2, Mas2, Adek2, yang lagi berkutat di Data Entry, ini ada beberapa formula Excel yang biasa dipakai untuk Data Entry, Content Uploaer, Data Migration, semacam saya ini :D so here are the details:
SPLIT TEXTS INTO CELLS
If you want to take the texts out from a certain column into multiple cells needed. For example:
SPLIT TEXTS INTO CELLS
If you want to take the texts out from a certain column into multiple cells needed. For example:
Select the cell containing the text you want to split, go to Data > Text to Columns, choose Delimited
(because in your source text you have space/comma/else as separator) > Next
(because in your source text you have space/comma/else as separator) > Next
Choose the Delimiter options > Next
Choose Column data format > "Table" button on destination
Delete the predefined destination cell
> choose the cells destination > "Table" button on destination > Finish
HERE'S THE RESULT:
NOTE: If there is any possibility you meet the combined text & number, and combined separator,
the steps remain the same but you need to mark other options on the delimiter:
the steps remain the same but you need to mark other options on the delimiter:
RESULT:
Hope it helps! see ya! :*