+ Reply to Thread
Results 1 to 6 of 6

Programmere celle

  1. #1
    Registered User
    Join Date
    03-18-2013
    Location
    Denmark
    MS-Off Ver
    Excel 2007
    Posts
    13

    Programmere celle

    Hej, excel entusiaster :-)
    Jeg har følgende komplikation:
    Jeg har et ord indtastet i en celle, jeg ville derfor om spørge om der er mulighed for om der en formel der kan observere det sidste bogstav i ordet. Hvis dette kan lade sig gøre skal jeg spørge om den kan observere hvad endelsen er og hvis endelsen er l skal den i en anden celle fjerne programmeringen der sætter -en på ordet og skal så istedet kun sætte n på ordet.

    Tak på forhånd og håber i vil hjælpemig med at opstille en formel.

    Mvh. Frederik Jørgensen

  2. #2
    Registered User
    Join Date
    05-29-2005
    MS-Off Ver
    2013
    Posts
    36

    Re: Programmere celle

    Kære Mvh. Frederik Jørgensen

    Det ville være dejligt, hvis du kunne vedhæfte en prøve af excel ark sammen med det ønskede output, og jeg kunne forsøge at automatisere det for dig med en formel

  3. #3
    Registered User
    Join Date
    03-18-2013
    Location
    Denmark
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Programmere celle

    Kan først sende det til dig om et par timer :-)

  4. #4
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Excel for Windows & Mac - all versions.
    Posts
    25,195

    Re: Programmere celle

    Hello Frederik

    This post might appear to be a duplication of your Tal til bogstaver post.
    I say 'might appear' since my first language is not Danish and hence I can't be certain.

    Are you able to assure me that it is NOT a duplicate.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  5. #5
    Registered User
    Join Date
    03-18-2013
    Location
    Denmark
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Programmere celle

    Hey, Richard buttrey :-)
    That is not a duplicate, my problem in "tal til bogstaver" is that i will have it to write a word instead of a number.

    [I]n this thread is my question how to get a formular to look at the last character and if the charater is l shall it follow another rule :-)

  6. #6
    Registered User
    Join Date
    03-18-2013
    Location
    Denmark
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Programmere celle

    Hej ascool_asice, jeg lØste selv problemet:-)
    MEN PRISÆTTER AT DU TOG DIG TID :-)
    ELLERS TAK :-)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1