+ Reply to Thread
Results 1 to 3 of 3

add values before semicolon

  1. 11-06-2014, 02:45 AM #1
    a.hudrea
    a.hudrea is offline
    Forum Contributor
    Join Date
    07-22-2013
    Location
    Sibiu
    MS-Off Ver
    Excel 2007
    Posts
    114

    add values before semicolon

    test.xlsx
    I have attached an example of a desired result. And as the title says I want to sum the values that are before a semicolon. In some cells there could be only one value in another cell there could be up to three. Any advice would be really appreciated. Thank you very much.
    Last edited by a.hudrea; 11-06-2014 at 02:55 AM.
    Reply With QuoteRegister To Reply
  2. 11-06-2014, 07:05 AM #2
    MickG
    MickG is offline
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: add values before semicolon

    Try this on Your basic data (as shown in your attached file)
    NB:- This code will alter that data.
    Please Login or Register  to view this content.
    Regards Mick
    Reply With QuoteRegister To Reply
  3. 11-07-2014, 05:26 AM #3
    apo
    apo is offline
    Valued Forum Contributor
    Join Date
    03-22-2013
    Location
    Australia,NSW, Wirrimbi
    MS-Off Ver
    Excel 2013
    Posts
    1,057

    Re: add values before semicolon

    Here's another...

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ 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)

Similar Threads

  1. Transpose single row containing semicolon separated values to column
    By Wilco84 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-04-2013, 07:50 AM
  2. Concatenate Possibly null cells & delimiting semicolon, and delete ending semicolon if any
    By HopScotchNSoda in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-11-2013, 10:47 PM
  3. forumla to separate values with semicolon
    By kuder mcgavin in forum Excel General
    Replies: 5
    Last Post: 10-15-2012, 12:38 PM
  4. Formatting zip codes to semicolon deliminated values
    By mattjdohm in forum Excel General
    Replies: 2
    Last Post: 09-10-2008, 08:24 PM
  5. Column with semicolon-separated values
    By nsv in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-22-2006, 08:22 AM

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.6.0 RC 1