Forum Discussion

Michael Colwell's avatar
Michael Colwell
Copper Contributor
Feb 14, 2018

Combining text from two column's and creating a new list

Hi, hoping someone can help. Please see the table below. I'm trying to combine the "Base Code" and "Variant" column to produce the "Combined" column result. Hope that makes sense. Basically I w...
Excel
Excel Online
Formulas and Functions
Macros and VBA
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor

Michael,

 

would you consider a Power Query solution?

 

Michael Colwell's avatar
Michael Colwell
Copper Contributor
Feb 15, 2018

Hi Detlef,

 

Am not familiar with Power Query.

I've just Googled it and will need to look into it a bit further before I decide what to do, but thanks fo the advice.

 

Regards,

Michael.

  • Michael Colwell's avatar
    Michael Colwell
    Copper Contributor
    Feb 15, 2018

    Hi Detlef,

     

    Can't install Power Query as it requires the 64 bit Excel version, I'm reatricted to the 32bit version.

    Thanks for the suggestion.

    Any other ideas as to how I might achieve my column extraction & combining !!

    Am wondering if I need to look into some sort of VB option.

    Regarsds.

      • Michael Colwell's avatar
        Michael Colwell
        Copper Contributor
        Feb 16, 2018

        Hi Sergi,

        Thanks for the link, not sure how I missed that..!!

        Have installed and will try to work through combining the column's as per my original post.

         

        Regards.

Resources