Results 1 to 9 of 9

Thread: Excel help

  1. #1
    Join Date
    Dec 2007
    Location
    .../localhost/
    Posts
    6,005
    Rep Power
    30

    Default Excel help

    Treba mi par caka iz excel-a
    evo jedna ostalo kad zatreba

    imam kolonu u kojoj imam neke vrijednosti tipa : 1-GG1101 , 1-GG1104 , 1-GG1105 itd

    sad svaki ovaj br treba da dobije extenziju .jpg tj da bude 1-GG1101.jpg , 1-GG1104.jpg , 1-GG1105.jpg itd

    sad kako da ubacim extenziju tj kako dodati u svim poljima .jpg uz vece postojeci tekst a da se ne mijenja sve rucno posebno
    the World's leading dance event
    Sensation


  2. #2
    Join Date
    Aug 2006
    Posts
    162
    Rep Power
    16

    Default

    iskoristi funkciju concatenate. recimo da je u celiji A1 text, u B1 upisi formulu: =CONCATENATE(A1;".jpg")
    posle iskopiras formulu i u koloni B ces imati to sto si trazio...

  3. #3
    Join Date
    Dec 2007
    Location
    .../localhost/
    Posts
    6,005
    Rep Power
    30

    Default

    da da to je to

    =CONCATENATE(AG:AG,".jpg")

    zahvaljujem
    the World's leading dance event
    Sensation


  4. #4
    Join Date
    Dec 2007
    Location
    .../localhost/
    Posts
    6,005
    Rep Power
    30

    Default

    help no.2

    u koloni AG imam tekst tipa "Primjer teksta koji sadrzi promijenjive x,y,z"

    sad u kolonama npr AG AC AB su mi vrijednosti promjenivih x y z koje treba zamijeniti u koloni AG

    the World's leading dance event
    Sensation


  5. #5
    Join Date
    Nov 2008
    Location
    Podgorica
    Posts
    6,864
    Rep Power
    10756

    Default

    Vjerujes li mi, da sam to ovaj semestar sve imao za kolok da radim i za ispit, samo smo mi pravili VBA funkcije i cuda koja su bila po 20 redova duga a ti samo trazis jednu funkciju koju kucas u kolonu, a mi smo na potpuno crnji nacin to radili...
    Ne ja necu da ti pomognem jer sam sve zaboravio a predmet mi se ukrvio, ali cisto htjedoh da se pohvalim
    Njak Njak Njak

  6. #6
    Join Date
    Jun 2010
    Location
    Temples of Syrinx
    Posts
    4,139
    Rep Power
    27977

    Default

    Quote Originally Posted by Gorostas View Post
    Vjerujes li mi, da sam to ovaj semestar sve imao za kolok da radim i za ispit, samo smo mi pravili VBA funkcije i cuda koja su bila po 20 redova duga a ti samo trazis jednu funkciju koju kucas u kolonu, a mi smo na potpuno crnji nacin to radili...
    Ne ja necu da ti pomognem jer sam sve zaboravio a predmet mi se ukrvio, ali cisto htjedoh da se pohvalim

  7. #7
    Join Date
    Dec 2007
    Location
    .../localhost/
    Posts
    6,005
    Rep Power
    30

    Default

    niste od pomoci vas dvojica :P

    bilo ko neki predlog?

    ako nisam dobro objasnio mogu ponoviti
    the World's leading dance event
    Sensation


  8. #8
    Join Date
    Dec 2007
    Location
    .../localhost/
    Posts
    6,005
    Rep Power
    30

    Default

    iskoristih SUBSTITUTE i rijesih stvar
    Last edited by dnikola; 08-01-11 at 11:18.
    the World's leading dance event
    Sensation


  9. #9
    Join Date
    Aug 2008
    Location
    Cetinje-Podgorica
    Posts
    2,595
    Rep Power
    5733

    Default

    http://www.scribd.com/doc/11954216/Excel-Skripta Potrazi ovdje,trebalo bi da nadjes to..
    " Ko te kara,nek ti piše pjesme! "


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel help
    By ThaHool in forum Software, IT generalno
    Replies: 2
    Last Post: 17-11-10, 14:31
  2. tutorijal za excel
    By laciale in forum Software, IT generalno
    Replies: 3
    Last Post: 26-02-10, 19:11
  3. Excel Problem
    By kambodza in forum Software, IT generalno
    Replies: 25
    Last Post: 12-01-08, 10:11
  4. Excel
    By cpu in forum Software, IT generalno
    Replies: 9
    Last Post: 13-10-07, 11:11
  5. M$ Excel 2007 bug!
    By hAlleLuJa in forum Software, IT generalno
    Replies: 1
    Last Post: 27-09-07, 11:02

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •