+ Reply to Thread
Results 1 to 1 of 1

Help with merging nonblank cells into a single string

  1. #1
    Registered User
    Join Date
    06-10-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    1

    Help with merging nonblank cells into a single string

    Hi Everyone,

    I am collecting Panini 2012 stickers
    I have created a spreadsheet which shows which stickers I need and which I have doubles of. Ideally I'd like to be able to merge the cells containing numbers of the stickers I need into a single string and the ones I have doubles of into a different string (i.e. 34, 56, 79, 123, 134, 156 etc etc). The relevant data is in columns H and I and I need to remove the blank cells.
    I've attached the sheet I've created here - can anyone help? I've never used macros before, but suspect I might need one here?
    Thanks in advance!
    Jim
    Attached Files Attached Files

+ 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