+ Reply to Thread
Results 1 to 2 of 2

Thread: Concatenate option

  1. 06-29-2011, 11:20 AM #1
    nirola
    nirola is offline
    Registered User
    Join Date
    02-20-2008
    Posts
    40

    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.
    Reply With Quote Reply With Quote
  2. 06-29-2011, 11:22 AM #2
    mhuston
    mhuston is offline
    Forum Contributor
    Join Date
    10-16-2008
    Location
    Iowa
    Posts
    120

    Re: Concatenate option

    If this is a one time task, I would just copy into notepad++ and replace each return with a space.
    Reply With Quote Reply With Quote
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.2.0