Results 1 to 6 of 6

Concatenation Function

Threaded View

Jakz34 Concatenation Function 03-18-2011, 01:10 PM
NBVC Re: Concatenation Function 03-18-2011, 01:16 PM
Jakz34 Re: Concatenation Function 03-18-2011, 01:19 PM
NBVC Re: Concatenation Function 03-18-2011, 01:21 PM
Jakz34 Re: Concatenation Function 03-18-2011, 01:48 PM
NBVC Re: Concatenation Function 03-18-2011, 02:37 PM
  1. #1
    Registered User
    Join Date
    03-18-2011
    Location
    Jonesboro, AR
    MS-Off Ver
    Excel 2010
    Posts
    13

    Concatenation Function

    I have data in columns A2 through BK2 and I want to concatenate these into one cell. My problem is I need a comma and space between each concatenated item.

    Example: If I have John in A2, William in B2 and Doe in C2 I want to concatenate them but....

    instead of looking like this:

    JohnWilliamDoe

    It would look like this:

    John, William, Doe

    Is there a simple way to do this other than make a new column full of spaces and a new column full of commas and concatenating those between each cell? The way I have it setup I have placed the columns of spaces and texts but I am going to have to do =CONCATENATE(A2,BM2,BN2,B2,BM2,BN2,C2........all the way through BK2. Surely there is a simpler way or am I stuck?
    Last edited by Jakz34; 03-18-2011 at 01:14 PM.

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