Results 1 to 8 of 8

Transpose and Concatenate help

Threaded View

Ainsley Transpose and Concatenate help 05-06-2015, 10:52 AM
igoodable Re: Transpose and Concatenate... 05-06-2015, 10:55 AM
Ainsley Re: Transpose and Concatenate... 05-06-2015, 11:08 AM
mahju Re: Transpose and Concatenate... 05-06-2015, 11:10 AM
Ainsley Re: Transpose and Concatenate... 05-06-2015, 11:19 AM
mahju Re: Transpose and Concatenate... 05-06-2015, 11:23 AM
AlKey Re: Transpose and Concatenate... 05-06-2015, 11:34 AM
AlKey Re: Transpose and Concatenate... 05-06-2015, 11:29 AM
  1. #1
    Registered User
    Join Date
    02-27-2006
    Location
    Oxford England
    MS-Off Ver
    2007
    Posts
    54

    Transpose and Concatenate help

    Hi, I have a long list of numbers in column A (A2:A50) and I need to show these in one single cell. With a space separating each number.

    How do I do that ? I've tried to concatenate and transpose in one go and can get them all in one cell, but without a space. I tried to put a column of spaces in B, but still couldn't make it work.

    Many thanks.
    Last edited by Ainsley; 05-06-2015 at 11:19 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 08-28-2014, 03:53 PM
  2. VBA Macro to Transpose Columns to Rows AND Concatenate Afterwards
    By ljanak in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-01-2013, 03:16 PM
  3. [SOLVED] VBA or forumla. Concatenate, transpose
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-01-2012, 04:01 PM
  4. [SOLVED] Transpose: How can I copy a list and transpose it but leaving 3 cells in between each item
    By cocolete in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-11-2012, 10:01 AM
  5. Replies: 2
    Last Post: 02-19-2007, 04:53 PM

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