+ Reply to Thread
Results 1 to 3 of 3

Thread: Merge data from 2 cells

  1. 02-11-2012, 06:25 AM #1
    Enzo137
    Enzo137 is offline
    Registered User
    Join Date
    02-11-2012
    Location
    Victoria, Australia
    MS-Off Ver
    Excel 2007
    Posts
    2

    Post Merge data from 2 cells

    can any one help me.
    I have 2 columns of data and need to merge the data into 1 cell.
    For instance, column A contains data like "Extra Strength TPE gloves" and column B contains data like "medium".
    I need a formula or VBA that merges the data like this, "Extra Strength TPE medium gloves".
    The data contained in column B must be inserted after the TPE in column A.

    Thanks
    Reply With Quote Reply With Quote
  2. 02-11-2012, 06:39 AM #2
    bebo021999
    bebo021999 is offline
    Valued Forum Contributor
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2007
    Posts
    455

    Re: Merge data from 2 cells

    Try this in C1:
    =LEFT(A1,SEARCH("TPE",A1,1)+3)&B1&MID(A1,SEARCH("TPE",A1,1)+3,256)
    Click the star icon in left-corner of my post if you find my post userful!

    Quang PT
    quangphanidico@yahoo.com
    PM me: Y!M: quangphanidico
    Reply With Quote Reply With Quote
  3. 02-11-2012, 07:01 AM #3
    Enzo137
    Enzo137 is offline
    Registered User
    Join Date
    02-11-2012
    Location
    Victoria, Australia
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Merge data from 2 cells

    Perfect, thanks for your help
    Reply With Quote Reply With Quote
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.2.0