+ Reply to Thread
Results 1 to 3 of 3

space between text strings with concatenate

  1. #1
    Jeff
    Guest

    space between text strings with concatenate

    I'm using the concatenate function to join two bits of text - but I want a
    space between, and the function joins them together without a space. How
    can I insert a space into the resulting text please? (It seems to me that
    we would want such a space in ANY two text strings which we join together
    with concatenate - wouldn't we?? Why doesn't it put one in by default?!)

    Thanks
    Jeff



  2. #2
    Niek Otten
    Guest

    Re: space between text strings with concatenate

    Hi Jeff,

    =text1&" "&text2

    --

    Kind Regards,

    Niek Otten

    Microsoft MVP - Excel

    "Jeff" <no_em@ilplease> wrote in message news:[email protected]...
    > I'm using the concatenate function to join two bits of text - but I want a
    > space between, and the function joins them together without a space. How
    > can I insert a space into the resulting text please? (It seems to me that
    > we would want such a space in ANY two text strings which we join together
    > with concatenate - wouldn't we?? Why doesn't it put one in by default?!)
    >
    > Thanks
    > Jeff
    >




  3. #3
    Jason Morin
    Guest

    Re: space between text strings with concatenate

    CONCATENATE is a worthless function. You can join text
    strings using the ampersand (&). To add a space, use:

    =A1&" "&A2

    HTH
    Jason
    Atlanta, GA

    >-----Original Message-----
    >I'm using the concatenate function to join two bits of

    text - but I want a
    >space between, and the function joins them together

    without a space. How
    >can I insert a space into the resulting text please?

    (It seems to me that
    >we would want such a space in ANY two text strings which

    we join together
    >with concatenate - wouldn't we?? Why doesn't it put one

    in by default?!)
    >
    >Thanks
    >Jeff
    >
    >
    >.
    >


+ 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