Forum Discussion

radfordsix's avatar
radfordsix
Copper Contributor
Sep 06, 2018

Combine data from 2 columns into 1 column

I want to do this, but with 2 columns of data.  We have a sheet with area codes in one field and phone numbers in another.  I need the 2 pieces of data in one field for a list of 500 phone numbers.  ...
excel
Excel Online
Formulas and Functions
  • JessyVision's avatar
    JessyVision
    Copper Contributor
    Jun 10, 2024
    Hey all I used it by using "Flash Fill" - here is the example video that helped me: https://www.youtube.com/watch?v=1-U4RAj9qec
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Jun 10, 2024

      JessyVision 

      Link is correct, something is wrong with Microsoft servers or channels. Breaks even on root of support

      If refresh from time to time it could appear.

      Anyway, formula in general shall work.

      You may see formula text instead of the result if Show formula is ON

      Flash Fill is good enough, but please be careful with it. Sometimes it could give wrong results, especially on big data arrays.

       

       

    • JessyVision's avatar
      JessyVision
      Copper Contributor
      Jun 10, 2024

      SergeiBaklan 1. Here is my error

       

      You can see the formula just doesn't work. Yes, I do have automatic calculations selected.

       

      2. The example link you provided also doesn't work. Yes, my internet is fine (or I wouldn't be able to post this comment).

       

       

      • qdog's avatar
        qdog
        Copper Contributor
        Apr 23, 2026

        I had this issue, too! The formula worked when I changed the text from "Text" to "General" and then hit enter again.