Results 1 to 9 of 9

Thread: Excel

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User
    Join Date: Nov:2005
    Location: Sofia
    Posts: 118

    Excel

    , , PROPER, !

  2. #2
    Registered User entium's Avatar
    Join Date: May:2003
    Location:
    Posts: 1,426
    EP43-DS3|E5200@3.33|ASUS EN9800GT HB /HTDI/ 512MB|2X2GB 800MHZ CL5 A-DATA|WD2500JB|NEC 4750A|BELINEA 1980S2

  3. #3
    Registered User
    Join Date: Nov:2005
    Location: Sofia
    Posts: 118
    . "=SUBSTITUTE(LOWER(C2),CHAR(CODE(C2)),UP PER(CHAR(CODE(C2))),1)", "The formula you typed contains an error". excel 2007 . "Use system separators", .

  4. #4
    XaMaB's Avatar
    Join Date: Nov:2001
    Location:
    Posts: 20,392
    UP PER ,
    : XaMaB; . 0.42

    In God we Trust (all others must submit a X.509 certificate). , ()

  5. #5
    Registered User
    Join Date: Nov:2005
    Location: Sofia
    Posts: 118
    .

  6. #6
    XaMaB's Avatar
    Join Date: Nov:2001
    Location:
    Posts: 20,392
    2007
    Code:
    =SUBSTITUTE(LOWER(C2);CHAR(CODE(C2));UPPER(CHAR(CODE(C2)));1)
    : XaMaB; . 0.42

    In God we Trust (all others must submit a X.509 certificate). , ()

Posting Permissions

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

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |