General discussion

  • Creator
    Topic
  • #2130829

    Combining Data from 3 cells in Excel

    Locked

    by loydster ·

    This is in Excel 97, but I don’t think it matters too much. I have about 6000 phone numbers in an excel worksheet. This is 6000 rows, by 3 columns. One column for Area code, one for exchange, and one for number. I need to combine this into one column. (Obviously, I will still have 6000 rows.)
    It is date from an old mainframe, so the number was broken into 3 fields.
    Thanks

All Comments

  • Author
    Replies
    • #3546856

      Combining Data from 3 cells in Excel

      by don christner ·

      In reply to Combining Data from 3 cells in Excel

      You can use the concantenate function or just use the & symbol. If the columns are numbers you need to change them into strings. If they are text in the next column just type =a1&b1&c1 and hit enter. Drag the formula down the column.

      If they are numbers, in the next column type =str(a1)&str(b1)&str(c1).

      Don

    • #3546853

      Combining Data from 3 cells in Excel

      by frederick bauer ·

      In reply to Combining Data from 3 cells in Excel

      Here is something to try insert a new field after your three fields.
      Example
      A=area code
      B=exchange
      c=number
      Make column D use the concatenate formula
      =CONCATENATE(A2,B2,C2)

      or use this for formated fields with dashes
      =CONCATENATE(A1,”-“,B1,”-“,C1)

      Then if you need you can insert a Col E and copy D and paste special in Col E by right clicking the selecting values when you paste. Then you could remove colums a thru d and have a formated phone number field.

      Any questions please e-mail me!

    • #3567383

      Combining Data from 3 cells in Excel

      by loydster ·

      In reply to Combining Data from 3 cells in Excel

      This question was closed by the author

Viewing 2 reply threads