Results 1 to 5 of 5

Concatenate cells and add text

Threaded View

  1. #1
    Forum Contributor Rick_Stanich's Avatar
    Join Date
    11-21-2005
    Location
    Ladson SC
    MS-Off Ver
    Office365
    Posts
    1,177

    Concatenate cells and add text

    I cant quite get this, I have 4 cells in one row (a selection and can be any row), I need to string the values together and add some simple text.
    Example:
    Assume row 1 and columns A, B, C, D.

    496 | 6d7 | Minor | Ø.375 +/-.010
    What I need this to read as one long string:
    #496, 6d7, Minor, Ø.375 +/-.010
    Adding the text in Red.

    Column A may be a single digit or up to 10 digits in length.
    Once the string is configured I want to copy it and manually paste in another application. If the string is placed any where else in the worksheet for formatting, it can be deleted after the copy/paste or macro end.

    As always, help is appreciated.
    Last edited by Rick_Stanich; 02-10-2009 at 01:54 PM.
    Regards

    Rick
    Win10, Office 365

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