Zapišimo podatke iz enega v dva stolpca

Excel omejuje pri delu s seznami zgolj z domišljijo. Ne verjamete?

Karkoli si zamislimo, lahko uresničimo. Da lahko učinkovito sledimo svojim željam, je potreben predpogoj le ustrezna priprava podatkov. Seznam na sliki je lep primer (ne)omejenosti uporabe.

Vsi podatki so v enem stolpcu. Želimo jih razbiti v dva stolpca.

'Vaša želja je zame ukaz', nam sporoča Excel in nam v različici 2007 ponudi izbiro na kartici Podatki | skupina ukazov Podatkovna orodja | Besedilo v stolpce. Po sprehodu skozi čarovnika je želja izpolnjena.

Naj spomnimo, poiščite nas, če bo čarovnik za razbijanje podatkov deloval v nasprotju z vašimi željami .

Excel 2007 osnovni

Napredno znanje Excela

Še več trikov?

Obiščite tečaj po vaši izbiri in spoznajte dodatne trike za večjo učinkovitost:

  • Excel za računovodje: Za učinkovito urejanje podatkov, pripravo izpisov in analiziranje. Spoznajte delo s formulami in funkcijami za izračun podatkov.
  • Excel VBA: Avtomatizirajte pogosta opravila v Excelu!
  • Excel za napredne poslovne analize: Pogosto delate poslovne analize? Iz nepregledne množice podatkov hitro izluščite pomembne in jih učinkovito prikažite.
Ocenite prispevek: Oceni z oceno 1 Oceni z oceno 2 Oceni z oceno 3 Oceni z oceno 4 Oceni z oceno 5
Povprečna ocena 9 uporabnikov je 4,44.
Pošljite komentar
Ime:
Email:
Poklic:
Vsebina:
Pogoji uporabe
Vaših povratnih informacij in vsebinskih vprašanj smo izredno veseli. Želimo si, da so objavljeni komentarji konstruktivni. Zato bomo vse komentarje, ki bodo vsebovali žaljivo vsebino, kletvice ali spodbujali nestrpnost in nasilje oz. ne bodo imeli vsebinske povezave z objavljenim prispevkom, primorani odstraniti.

V primeru žaljivih in neprimernih komentarjev si pridržujemo pravico, da zabeležimo IP naslov uporabnika.
12.08.2013 ob 15:21 | QfZdncXECmT
Note: I agree with John.I'm in the same boat as you're in, maybe even worse. First of all, I'm a 2nd year (not sophomore) maijrong in Mechanical Engineering at UNLV. You're certainly at a better university than me, but I pay cheaper tuition. lolAnyways, I took Calculus I once and received an A. I took Calculus II twice, first time F second time A-. I took Calculus III last semester, received D. I'm retaking it right now, most likely I'll get an A. I took Engineering Physics I (Mechanics) twice, first time I dropped and second time I received a C. My major doesn't require Physics II (Electromagnetism). So right now I'm taking Physics III (Thermo, Optics and Modern). So far I'm having a B in that class.As of now my GPA is 2.78. I wish it'd be 3.0 so I can get an internship this summer, but I guess I'll have to wait 'til next year when my GPA is higher. I want to point out that there are some people with high GPA, but they're not that smart. I know some people with 3.5+. On the physics exams, they sit next to their friends and work together. The professor didn't really pay attention, so they got A. When I study with them, they aren't really good at problem solving.This semester my statics professor allows 4 people to work in group on homework. Many of my friends are also in most of my classes. So I always with friends. Make sure you guys don't screw around when studying. I know a guy who always talks about Lamborshini when studying, so I don't like to study with him. After studying with friends at the library, go home to study by yourself, make sure that you understand the concept instead of memorizing. Last semester I studied up to midnight at the library by myself most of the time, because I didn't know how to study effectively. So I learn to study effectively. This semester I study effective and didn't study much at all, and I'm doing really well.As for your classes, it's okay to audit/drop the classes and retake them next semester. You don't have to rush through college. My EE professor once said, If you rush through things, you leave yourself with lots of free time to do noting and your life become boring. Anyways, it's better to take 12 credits/semester and get 3.5 than to take 15 and get 3.0. You're better at math than 95% of people on campus, so apply to be a math tutor or any campus job for about 20 hours per week. That way you can study on your down time. Make sure you have time to do fun stuff: gym, going out, etc. If you only study, what's the point of living?Personally, I wanted to be a mechanical engineer since I was young. I love building stuff. As for you, are you really interested in material science, or you're just in it for the a5. Keep in mind that any engineering job will get you a good pay check. So do something that you really like.Studying engineering is like anything in life. You have to hold on to it. It will be painful. I completely understand what you're going through. You're doing something that's much more difficult than most people on campus. Please stick with engineering, if not material science. It will pay off. Imagine you're future everyday. If you're not an engineer, what would you be doing? Personally, I'd be a bum.These qualities are what I believe a great engineer should have, listing by the order of importance:1) Imagination/creativity/enthusiasm2) Math/physics/problem solving3) Leadership4) People/business/selling skillsThe first, and most important, qualities are what you're already born with. It's who you are that makes you want to be an engineer. The second qualities are what you're studying in college right now. The third and fourth qualities are what you'll learn in clubs, jobs, internships and meeting new people.I don't know what else to say. Just please keep up your enthusiasm and never give up.Edit: Also keep in mind that the system is design for students to fail.Edit: Sometimes it isn't just about academics which will give you a great career. Consider this scenario. Two graduates applied for a job. One student graduated with a 3.5 GPA, has a few internships and activities. Another graduated with a 2.0, has a few internships, activities and hold 3 patents. Which graduate would impress the employer more?
28.04.2010 ob 15:05 | Uroš Prah
@Marija: mene pa zanima 'kontra' ukaz - ko imas recimo podatke v vec stoklpcih in jih zelis zdruziti v enega.

V tem primeru je najboje uporabiti funkcijo za združevanje nizov. V Microsoft Excelu je to funkcija =CONCATENATE()
28.04.2010 ob 10:35 | marija
tole je res uporabno.
mene pa zanima 'kontra' ukaz - ko imas recimo podatke v vec stoklpcih in jih zelis zdruziti v enega.
vnaprej se zahvaljujem
26.10.2009 ob 16:04 | Zlatko
Dobra poanta, kako je kak dvojni priimek vnešen... tukaj žal Excel ne zna, kaj je priimek in kaj je dvojni priimek. A to ne pomeni, da ne gre. Podatke je potrebno prej pripraviti oz. prečistiti. Naj nakažem rešitev, velja za Excel 2007 (predpostavljam, da so podatki v stolpcu A): =IFERROR(IF(SEARCH(" ";A1;SEARCH(" ";A1)+1)>B1;REPLACE(A1;SEARCH(" ";A1;SEARCH(" ";A1)+1);1;"-"));A1) prekopiramo navzdol po seznamu in rezultat je "popravljen" seznam. Kako razumeti tole klobaso? na strani http://www.b2.eu/racunalniski-tecaji/excel-napredna-raba.aspx se skriva odgovor :) LP!
22.10.2009 ob 10:53 | PetraA
Jaaaa, vse lepo in prav, dokler nimaš bejbe, ki se je poročila in ima zdaj dva priimka. Če sta zapisana z vezajem, ok, kaj pa, če je vmes presledek, pol jih moraš pa spet "loviti" nazaj.?!
22.10.2009 ob 07:34 | Melita Sedmak
Ga. Vesna, dodajam še postopek v angleškem jeziku: Data | Data Tools | Text to Columns. Srečno!
21.10.2009 ob 14:45 | SONJA
hvala...res uporabno
20.10.2009 ob 21:00 | Jožica
Super ocena5
20.10.2009 ob 17:00 | ROMAN
Res ste super, kar tako še naprej. Probal sem na excel 2003 pa je uredilo besedilo tako, kot ste opisali tukaj. BRAVO !!!
20.10.2009 ob 11:29 | anibas
Preizkušeno, kako enostavno (če veš). Hvala
20.10.2009 ob 09:44 | Vida
B2 je super! Hvala za vse namige in znanje, ki nam ga posredujete!
20.10.2009 ob 08:48 | mateja
Ooo, kako enostavno....hvala!
20.10.2009 ob 08:12 | valerija
Super, hvala! Uporabno!
20.10.2009 ob 07:26 | Valerija
Hvala, zelo uporabno.
20.10.2009 ob 02:05 | MarkoJ
Hvala, deluje! Tako mi zdaj ne bo potrebno več prepisovati in brisati ali ime ali priimek.
19.10.2009 ob 19:23 | Vesna
Super nasvet! Morda lahko drugič napišete še ukaze tudi v angleščini za tiste, ki imamo angleške verzije...
19.10.2009 ob 14:24 | emira
Imenitno, hvala
Želite prejemati brezplačne računalniške trike in novice? Vpišite svoj elektronski naslov:
Ob prijavi boste prejeli tudi e-priročnik računalniških trikov na svoj elektronski naslov.
> Zakladnica trikov
  
B2 d.o.o., Tržaška 42, 1000 Ljubljana, T: 01 2444 202, M: info@b2.eu
B2 Facebook e-učenje