+ Reply to Thread
Results 1 to 2 of 2

Copy cell value to new cell and exclude all spaces in process

  1. #1
    Valued Forum Contributor
    Join Date
    11-20-2003
    MS-Off Ver
    2010, 2016
    Posts
    1,139

    Copy cell value to new cell and exclude all spaces in process

    I need to concat the value of 4 different cells in the same row. In the process, I need to remove all spaces in the calculated cells. The only requirement is I need to leave the original data intact and, if possible, use the existing code, but with modifications. Thanks

    For example, 4 cells as follows:

    A2 = 123456
    C2 = LE MANS
    D2 = 410 STREET
    F2 = 789

    The concat of G2 would be (including "|" to seperate each cell):
    G2 = 123456|LEMANS|410STREET|789

    Small sample attached if needed.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by maacmaac; 12-28-2011 at 05:12 PM.

  2. #2
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,417

    Re: Copy cell value to new cell and exclude all spaces in process

    Maybe try this:

    Please Login or Register  to view this content.
    abousetta
    Please consider:

    Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
    Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.

+ 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