Results 1 to 7 of 7

Sum & Separate numbers in text

Threaded View

BGri5th Sum & Separate numbers in... 06-22-2010, 08:48 AM
Rahul Nagar Re: Sum & Seperate numbers in... 06-22-2010, 09:00 AM
martindwilson Re: Sum & Seperate numbers in... 06-22-2010, 09:14 AM
Rahul Nagar Re: Sum & Seperate numbers in... 06-22-2010, 09:24 AM
BGri5th Re: Sum & Seperate numbers in... 06-22-2010, 10:35 AM
martindwilson Re: Sum & Separate numbers in... 06-22-2010, 11:06 AM
BGri5th Re: Sum & Separate numbers in... 06-22-2010, 12:46 PM
  1. #1
    Registered User
    Join Date
    06-22-2010
    Location
    Ann Arbor, MI
    MS-Off Ver
    Excel 2003
    Posts
    3

    Question Sum & Separate numbers in text

    Formats didn't hold below so I attached a spread sheet to make the columns and rows clearer.Below is a sample of what I have mixed over 45 cells. For all cells in column A that are "FIC" I need the dollars (that are mixed with text in column C) totaled (Column B would be blank). For all cells in column A that are "Outside". I need Column C to just be the dollars (no text). If Column A is "GSU" then I need the number following "Total Value" in column C.
    A B C
    1 FIC IV1234 MV: $26,453.42***Blah Blah text (IRA)
    2 FIC NV1234 MV: $1,307.76***Blah Blah text (IRA)
    3 Outside 12345 Market Value: $251,655.62***Blah Blah text
    4 GSU 6Z1234 $35.29***MONEY $42,676.95***(PNRA) Total Value: $42,712.24

    How can I get totaled and formated something like this:
    A B C
    5) FIC $27,761.19
    6) Outside 4393829 $251,655.62
    7) GSU 6ZE155196 $42,712.24

    Any suggestions?
    Attached Files Attached Files

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