+ Reply to Thread
Results 1 to 2 of 2

Concatenate option

  1. #1
    Registered User
    Join Date
    02-20-2008
    Posts
    50

    Concatenate option

    Hi Members,

    I have 900 roll numbers (numeric 6 digit) in column A i want to put all these roll numbers in single cell with space in between each of them - all 500 roll numbers should come in single cell e.g C1.
    I know that we can do this with concatenate but that is to lenghty process so need ur help.

    Thanks..
    Last edited by nirola; 06-29-2011 at 11:22 AM.

  2. #2
    Forum Contributor
    Join Date
    10-16-2008
    Location
    Iowa
    Posts
    121

    Re: Concatenate option

    If this is a one time task, I would just copy into notepad++ and replace each return with a space.

+ 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