Results 1 to 7 of 7

Split string and apply function on string parts

Threaded View

  1. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Split string and apply function on string parts

    With the sample text in A1
    This regular formula seems to calculate the correct values:
    =IFERROR(SUMPRODUCT((INDEX(--TRIM(MID(SUBSTITUTE("+"&A1,"+",REPT(" ",LEN(A1))),LEN(A1)
    *ROW(INDIRECT("1:"&LEN(A1)-LEN(SUBSTITUTE(A1,"+",""))+1)),LEN(A1))),0)^2)/(4*PI())),0)
    EDITED TO INCLUDE THIS ALTERNATIVE:
    This seems to work fine, also
    =IFERROR(SUMPRODUCT(((0&TRIM(MID(SUBSTITUTE(A1,"+",REPT(" ",100)),(ROW(INDIRECT("1:"&(LEN(A1)
    -LEN(SUBSTITUTE(A1,"+",""))+1)))-1)*100+1,100)))^2)/(4*PI())),0)
    Is that something you can work with?
    Last edited by Ron Coderre; 09-24-2015 at 04:32 PM.
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Split String at every "/" then put split string results into a multiline textbox.
    By Andrew Andromeda in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2015, 01:49 AM
  2. Advanced Split Function: Need to pull text string in quotes, within a text string
    By Zamboni in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-27-2013, 04:38 PM
  3. [SOLVED] Split a string into parts
    By LeahS in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-01-2013, 09:33 AM
  4. [SOLVED] Searching a string to see if two parts of the string are equal
    By cheal2 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-18-2013, 09:58 AM
  5. Split String into 4 Parts - Max 30 Characters per Cell and Whole Words
    By keithm_007 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-22-2012, 05:56 AM
  6. [SOLVED] Dim String, and divide/split into parts
    By Hallet in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-19-2012, 12:37 PM
  7. Can excels Split() function split a string up at multiple spots?
    By 111StepsAhead in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-14-2011, 02:36 PM

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