Excel Formula question

Discussion in 'Software' started by John Neerdael, Feb 16, 2009.

  1. John Neerdael

    John Neerdael Nibble Poster

    80
    0
    26
    Hey guys, I'm a complete noob on Excel formula's. I have a excel spreadsheet, colom A contains the first name, colom B the name. I want to have a formula for colom C that outputs the 1st letter of 1A + the entire field 1B.
    So for me it would be
    1A = John
    1B = Neerdael
    1C = JNeerdael
    But with a formula.

    Can anyone help?

    edit: It should remove any spaces in the 1B field, so for a name: John Van Neerdael it should become JVanNeerdael
     
    WIP: MCTS: 70-640
  2. Notes_Bloke

    Notes_Bloke Terabyte Poster

    3,230
    54
    146
    Hi John,
    This should work for you:-

    =LEFT(A1,1)&B1

    In your example paste the formula into cell C1.

    NB
     
    Certifications: 70-210, 70-215, A+,N+, Security+
    WIP: MCSA
  3. craigie

    craigie Terabyte Poster

    3,020
    174
    155
    1C =LEFT(A1,1)
    1D =CONCATENATE(A3,A2)
     
    Certifications: CCA | CCENT | CCNA | CCNA:S | HP APC | HP ASE | ITILv3 | MCP | MCDST | MCITP: EA | MCTS:Vista | MCTS:Exch '07 | MCSA 2003 | MCSA:M 2003 | MCSA 2008 | MCSE | VCP5-DT | VCP4-DCV | VCP5-DCV | VCAP5-DCA | VCAP5-DCD | VMTSP | VTSP 4 | VTSP 5
  4. Qs

    Qs Semi-Honorary Member Gold Member

    3,081
    70
    171
    Best way to do it ^^

    Qs
     
    Certifications: MCT, MCSE: Private Cloud, MCSA (2008), MCITP: EA, MCITP: SA, MCSE: 2003, MCSA: 2003, MCITP: EDA7, MCITP: EDST7, MCITP: EST Vista, MCTS: Exh 2010, MCTS:ServerVirt, MCTS: SCCM07 & SCCM2012, MCTS: SCOM07, MCTS: Win7Conf, MCTS: VistaConf, MCDST, MCP, MBCS, HND: Applied IT, ITIL v3: Foundation, CCA
  5. craigie

    craigie Terabyte Poster

    3,020
    174
    155
    I like to make things hard for myself :D
     
    Certifications: CCA | CCENT | CCNA | CCNA:S | HP APC | HP ASE | ITILv3 | MCP | MCDST | MCITP: EA | MCTS:Vista | MCTS:Exch '07 | MCSA 2003 | MCSA:M 2003 | MCSA 2008 | MCSE | VCP5-DT | VCP4-DCV | VCP5-DCV | VCAP5-DCA | VCAP5-DCD | VMTSP | VTSP 4 | VTSP 5
  6. John Neerdael

    John Neerdael Nibble Poster

    80
    0
    26
    Thanks guys :)
     
    WIP: MCTS: 70-640

Share This Page

Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.