Results 1 to 3 of 3

add values before semicolon

Threaded View

a.hudrea add values before semicolon 11-06-2014, 02:45 AM
MickG Re: add values before... 11-06-2014, 07:05 AM
apo Re: add values before... 11-07-2014, 05:26 AM
  1. #1
    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.

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. 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1