Reverse of Text to Columns

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Reverse of Text to Columns

  1. #1
    Board Regular
    Join Date
    Aug 2002
    Posts
    145
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Reverse of Text to Columns

     
    Just wondering if there's an easy way to do the reverse of the Text to Columns function. I have a spreadsheet with First Name in column A, Middle Init in column B and Last Name in column C. In column D, I'd like to have First (space) Middle (space) Last. Do I need a macro to do this or is there a built-in function in Excel of which I'm unaware?

    Thanks,
    Ed

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,444
    Post Thanks / Like
    Mentioned
    10 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Reverse of Text to Columns

    Quote Originally Posted by edzzz
    Just wondering if there's an easy way to do the reverse of the Text to Columns function. I have a spreadsheet with First Name in column A, Middle Init in column B and Last Name in column C. In column D, I'd like to have First (space) Middle (space) Last. Do I need a macro to do this or is there a built-in function in Excel of which I'm unaware?

    Thanks,
    Ed

    =A1&" "&B1&" "&C1

    Better

    =A1&IF(B1<>""," "&B1,"")&" "&C1

  3. #3
    Board Regular
    Join Date
    Aug 2002
    Posts
    145
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Wow, that was fast! Thanks Aladin. Worked like a charm.

    Ed

  4. #4
    New Member
    Join Date
    Jun 2011
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Reverse of Text to Columns

    what if you want to insert a comma when "reversing text to column function? for instance, if you're doing this with dates and want to make June 23 2011 => June 23, 2011 ?

  5. #5
    MrExcel MVP
    Join Date
    Dec 2008
    Location
    Phoenix, Arizona
    Posts
    6,150
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Reverse of Text to Columns

    Are the "dates" actually being recognized as dates in the formula bar? If yes, you should be able to just change the number format of the cell.

  6. #6
    New Member
    Join Date
    Jun 2011
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Reverse of Text to Columns

      
    yes, appear as is. dates. changing format to dates and numbers, but neither does the trick though.

User Tag List

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