Postoji alat u Excelu baš za tu svrhu i mnogo je bolje koristiti njega u fazi sređivanja podataka nego isti posao obavljati "izračunavanjem" tj formulama.
Alat se zove
Text to Columns i nalazi se na
Data kartici. Radi tako što parsira odnosno cepa obeleženi segment u kolone prema nekom izabranom simbolu, u ovom slučaju to će biti ";".
Have you found helpful examples, solutions or ideas-in-work, please consider the
following:
• Citation of *actual page* you are going to using is welcome.
• Have you saw "Value Added" examples you are going to incorporate to your
profitable blog, daily job or any money making venture: How about online donation?
↗Ana & Vlade Divac Foundation
Hvala!