+ Reply to Thread
Results 1 to 4 of 4

Merge two column with text separating two value

  1. #1
    Registered User
    Join Date
    09-22-2010
    Location
    Courtice, Ontario, Canada
    MS-Off Ver
    MS Office 2010
    Posts
    36

    Merge two column with text separating two value

    I got macro (thanks to this forum) to join two selected column and I need to put x to separate both values. How to do it?
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by mdbdesign; 10-07-2010 at 02:34 PM.
    Marek

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Merge two column with text separating two value

    Without VBA =a3&"x"&b3

  3. #3
    Registered User
    Join Date
    09-22-2010
    Location
    Courtice, Ontario, Canada
    MS-Off Ver
    MS Office 2010
    Posts
    36

    Re: Merge two column with text separating two value

    Thank you for that, but above macro is only part of actual code I need to accomplish to generate my spreadsheet as I need it. Is there way to incorporate function into macro?
    Sorry but I am mostly Auto CAD user and still thinking CAD way when creating any programing.

  4. #4
    Registered User
    Join Date
    09-22-2010
    Location
    Courtice, Ontario, Canada
    MS-Off Ver
    MS Office 2010
    Posts
    36

    Re: Merge two column with text separating two value

    Just bumping - I really need it, please.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1