Forum Discussion

ELAIR7's avatar
ELAIR7
Copper Contributor
May 22, 2024
Solved

Merging Columns in Excel

Hello -   I have a data set of around 19,000 rows of data, including addresses which span across 50 columns.    What I am trying to achieve, is for excel to review each row within the 50 columns ...
excel
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    May 22, 2024

    ELAIR7 If you have a modern Excel version (i.e. 365 or 2021) you can use TEXTJOIN.

     

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
May 22, 2024

ELAIR7 If you have a modern Excel version (i.e. 365 or 2021) you can use TEXTJOIN.

 

ELAIR7's avatar
ELAIR7
Copper Contributor
May 22, 2024
it worked, thank you!

Resources