Results 1 to 2 of 2

Thread: Adding Spaces into Text
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jul 2019
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Talking Adding Spaces into Text

    Hi everyone!

    I used a concatenate formula to combine a set of address columns into a full address column.

    My only issue is that the spaces were not added between words. Can you help me do this?

    Currently all the addresses look like this:
    000 Peach StreetDentonTX76209

    How can I make a formula to add spaces in the required areas?

    Thank you in advance!

  2. #2
    Board Regular Scott T's Avatar
    Join Date
    Dec 2016
    Posts
    2,525
    Post Thanks / Like
    Mentioned
    18 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Adding Spaces into Text

    you need to add the spaces where you want them.

    for example

    BCDEF
    2123peach streetdentontx6209
    3
    4123 peach street denton tx 6209

    Sheet3



    Worksheet Formulas
    CellFormula
    B4=B2&" "&C2&" "&D2&" "&E2&" "&F2



    If you have access to textjoin then you can use that
    https://support.office.com/en-us/art...3-0e8fc845691c
    Colonel Sandurz: Prepare ship for light speed.
    Dark Helmet: No, no, no, light speed is too slow.
    Colonel Sandurz: Light speed, too slow?
    Dark Helmet: Yes, we're gonna have to go right to ludicrous speed.

Some videos you may like

User Tag List

Tags for this Thread

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
  •