EXCEL hitno potrebna pomoc

ZorzSCG

Početnik
Poruka
5
Molim pomoc za EXCEL

Kako mogu podatke iz jedne kolone
npr.
.............A......................
CD,98.00,9788684611095

podelit posebno u svaku kolonu
pa da dobijem npr.

.A................B................... C
CD............98,00......... 9788684611095

Da li postoji neka formula da ceo postupak uradim u par klikova misem
posto imam preko 1000 takvih primera
Evo dole samo nekih od njih

CD,98.00,9788684611095
CD,100.00,8606007104462
CD,129.00,8600278415302
CD,150.00,9788678080722
CD,179.00,9788690848904
CD,199.00,9788651300359
CD,200.00,9788690790302
CD,230.00,9788686303004
CD,250.00,9788686231017
CD,255.00,9788686217004
CD,270.00,9788685665042
CD,275.00,9788678081033
CD,350.00,9788677540395
CD,499.00,9788678260063
DVD,99.00,8606004619501
DVD,139.00,8606004619952
DVD,199.00,8606004644435
DVD,200.00,9788678081651
DVD,230.00,8606004619280
DVD,249.00,8606004619235
DVD,250.00,9788678140556
DVD,290.00,8605003133094
DVD,299.00,8606004619150
 

Back
Top