Results 1 to 4 of 4

How to collect data from many cells in a row into one cell?

Threaded View

  1. #1
    Registered User
    Join Date
    07-03-2010
    Location
    Lithuania
    MS-Off Ver
    Excel 2016
    Posts
    83

    How to collect data from many cells in a row into one cell?

    How to collect data from many cells in a row into one cell?

    I provided and example, how I want it be:
    A B C D E F G H I J K ...
    1 Diameter List of elements ...
    2 ∅6 9 1 3 5 9 1 3 5 ...
    3 ∅8 5 4 7 9 5 4 7 9 ...
    ... ... ... ... ... ... ... ... ... ... ... ... ...

    I have very long rows with many columns starting from column C, some cells are empty. In cell B2 I want to collect all data from cells of the row with single space between them. The same I want to do in cell B3 and downwards ...

    I know in Excell 2010, the cell can contain
    32767 characters maximum.
    Maybe it's better to export that list of elements to text file or use aditional reserved cells C2; D2; E2 - if the text doesn't fit to B2.

    Appreciate any help
    Last edited by rcurious; 01-20-2012 at 07:39 AM.

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