Results 1 to 4 of 4

Concatenate with space inbetween?

This is a discussion on Concatenate with space inbetween? within the Excel Questions forums, part of the Question Forums category; Good morning, I have two coloums First Name in Coloumn A and Last Name in Coloum B. I want to ...

  1. #1
    New Member
    Join Date
    Sep 2008
    Posts
    21

    Default Concatenate with space inbetween?

    Good morning,

    I have two coloums First Name in Coloumn A and Last Name in Coloum B.

    I want to concatenate them into Coloumn C but put a space in between the first and last name. Is there a way to do this? Each time I do it it writes the first & last name as all one word
    example JoneSmith I need Jone Smith

    Thanks for any assitance you can offer.

  2. #2
    MrExcel MVP
    Moderator
    Rediscovering the love
    Richard Schollar's Avatar
    Join Date
    Apr 2005
    Location
    UK
    Posts
    23,664

    Default Re: Concatenate with space inbetween?

    Formula wise it would be:

    =A1 & " " & B1

    copied down.
    Richard Schollar

    Using xl2013

  3. #3
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    25,584

    Default Re: Concatenate with space inbetween?

    Try:
    =A2&" "&B2
    Hope this helps, good luck.
    Peter

    - Read: Posting Guidelines, Forum Rules & FAQs
    - Want to post a small screen shot? Try one of these Excel jeanie, MrExcel HTML Maker or Borders-Copy-Paste (To test: Test Here)
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the VBHTML Maker

  4. #4
    New Member
    Join Date
    Sep 2008
    Posts
    21

    Default Re: Concatenate with space inbetween?

    Thank you I kept on missing the " " the space in between the quotes. Thanks again!

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com