Results 1 to 9 of 9

Sum of each cell having text string required in separate cell.

Threaded View

SyedTabassumAli Sum of each cell having text... 02-19-2020, 04:28 PM
Paul Re: Sum of each cell having... 02-19-2020, 04:48 PM
SyedTabassumAli Re: Sum of each cell having... 02-19-2020, 04:54 PM
dosydos Re: Sum of each cell having... 02-19-2020, 04:50 PM
SyedTabassumAli Re: Sum of each cell having... 02-19-2020, 05:02 PM
SyedTabassumAli Re: Sum of each cell having... 02-19-2020, 05:25 PM
Paul Re: Sum of each cell having... 02-19-2020, 05:11 PM
Paul Re: Sum of each cell having... 02-19-2020, 05:19 PM
Paul Re: Sum of each cell having... 02-19-2020, 05:27 PM
  1. #1
    Registered User
    Join Date
    08-28-2013
    Location
    Pakistan
    MS-Off Ver
    Excel 2019
    Posts
    41

    Post Sum of each cell having text string required in separate cell.

    I need sum of each cell
    I have tried multiple options but not able to
    Actually there are different text symbols like "+", "(", ")", and space
    I am stuck using Search / Find Function locating only one text symbol

    Cell values are like
    B3: 54 + 216 + 20
    B4: 5 + 148 + 87 + 5
    B5: 48 + (4+3) + 349 + 4

    Result required is
    C3: 290
    C4: 245
    C5: 166
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] 2 cell text lookup in text string to return data from separate column
    By Zivhodiva in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-08-2019, 03:03 PM
  2. [SOLVED] Formula or function to separate string of text in a cell to multiple columns
    By Chris McGlothen in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-29-2016, 12:10 PM
  3. [SOLVED] Separate the last word of a string of text in a cell
    By ClaireH in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-07-2013, 06:33 AM
  4. Separate out a text string in one cell, and break into into individual cells
    By StephenHall in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-05-2012, 03:45 PM
  5. Separate numbers embed in a text string into a new column or cell
    By DennyT48 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-23-2012, 04:14 PM
  6. Separate a string of text from a cell
    By albardit18 in forum Excel General
    Replies: 7
    Last Post: 06-03-2011, 04:22 PM
  7. Replies: 4
    Last Post: 01-17-2011, 11:44 PM

Tags for this Thread

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