+ Reply to Thread
Results 1 to 5 of 5

Create new Text by joining 2 columns

  1. #1
    Registered User
    Join Date
    02-02-2018
    Location
    fremont,ca
    MS-Off Ver
    2016
    Posts
    34

    Create new Text by joining 2 columns

    Good morning, I am attaching one excel file. please help.
    I also give/explain a few examples here

    A & B columns (First 2 Columns) are given, C Column is generated by taking size from Column A ( ml, L,oz) or POS wording( see last example) , then appending with Columns B.

    Thanks,
    James

    Column A Column B Clolumn C
    Macallan Double Cask Scotch Whiskey 86Pf 18Yr 6/750ml AK Macallan Double Macallan Double 750ml
    Harleston Green Blended Scotch Whisky 12/1L Harleston Harleston 1L
    Jack Daniel's POS Wood Chips 6 Bags Jack Daniel's Wood Chips Jack Daniel's Wood Chips POS
    Attached Files Attached Files
    Last edited by tao94539; 05-18-2020 at 12:09 PM.

  2. #2
    Registered User
    Join Date
    02-02-2018
    Location
    fremont,ca
    MS-Off Ver
    2016
    Posts
    34

    Re: Create new Text by joining 2 columns

    seems my example got mis formatted, please see my attachment to get better idea.

    Thanks,
    James
    Last edited by tao94539; 05-18-2020 at 12:10 PM.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,915

    Re: Create new Text by joining 2 columns

    Administrative Note:

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. No help to be offered until the link is provided.)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  4. #4
    Registered User
    Join Date
    02-02-2018
    Location
    fremont,ca
    MS-Off Ver
    2016
    Posts
    34

    Re: Create new Text by joining 2 columns


  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,915

    Re: Create new Text by joining 2 columns

    Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 02-19-2020, 09:37 AM
  2. [SOLVED] joining columns
    By kateaxe in forum Excel General
    Replies: 6
    Last Post: 05-26-2014, 06:13 PM
  3. Replies: 16
    Last Post: 08-21-2011, 11:08 PM
  4. Replies: 7
    Last Post: 05-27-2009, 11:14 AM
  5. Joining text in columns
    By yorkshirekid in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-23-2006, 02:18 PM
  6. [SOLVED] Joining Two Columns
    By Kartal in forum Excel General
    Replies: 4
    Last Post: 05-03-2006, 06:10 AM
  7. Joining Text in 2 Columns
    By inktec in forum Excel General
    Replies: 2
    Last Post: 01-25-2006, 08:40 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1