Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2002
    Location
    Texas, USA
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Data/Text-to-Columns Equivalent Function (MS/Excel

    The cited function will make columns from strings of data if you provide a delimiter. John David Doe, for example, is a string containing shorter strings delimited by spaces. The function will turn this into 3 columns in Excel. I have a need to do the opposite, that is, to take columns of data and convert them to strings within fewer columns. Using the same example of John David Doe in columns A (John), B (David), and C (Doe), I'd like to combine columns A and B into a single column A and have C remain unchanged.

    Is there a way to do this in Excel?

    TIA

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Data/Text-to-Columns Equivalent Function (MS/Excel

    This is a multi step process.

    Insert an empty column between columns B and C (this will be the new column C. Enter the following formula in cell C1 and copy it down as far as the strings in A & B go.

    <code>
    =TRIM(A1&" "&B1)
    </code>


    You should now have a column with the combined A and B.

    2- Select column C by clicking the C column head at the top of the column.

    3- Select Copy from the Edit menu.

    4- Select "Paste Special..." from the Edit menu. In the resulting dialog box, put a tic mark next to the "Values" in the Paste section. Click OK. The formulas in column C should now be replaced with the strings.

    5- Delete columns A & B.
    Legare Coleman

  3. #3
    3 Star Lounger
    Join Date
    Jan 2002
    Location
    Texas, USA
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Data/Text-to-Columns Equivalent Function (MS/E

    Thank you very much, Legare!

    It worked a charm. I knew there was function that would combine columns but couldn't dredge up the term 'trim'. Can't do a search if you don't know the words, I guess.

    Thank you again.

Posting Permissions

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