Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Feb 2009
    Location
    Kings Park, Victoria, Australia
    Posts
    90
    Thanks
    15
    Thanked 5 Times in 5 Posts
    I have the following text in a column "** CLAIMS ** YR2006 NO. 1 INC $1,885.46: YR2008 NO. 2 INC $11,750.00"

    What I want to do is separate out the no's inc and add them together in another column and then to separate out all the $ values in another column so that I end up with Claim No's Inc and Claim $

    Does anyone know a formula that can do this easily?

    Regards,
    Maria
    Maria
    Simmo7
    Victoria, Australia

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Can you upload a sample file with a before and after examples?

  3. #3
    Star Lounger
    Join Date
    Feb 2009
    Location
    Kings Park, Victoria, Australia
    Posts
    90
    Thanks
    15
    Thanked 5 Times in 5 Posts
    [quote name='mbarron' post='774237' date='08-May-2009 15:14']Can you upload a sample file with a before and after examples?[/quote]

    Here is a sample extracted from the original file, showing original text data and desired output into 2 columns.
    Attached Files Attached Files
    Maria
    Simmo7
    Victoria, Australia

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    I've added 2 UDFs to your file and used them in two additional columns (so you can check them against your figures!)
    Attached Files Attached Files
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    Star Lounger
    Join Date
    Feb 2009
    Location
    Kings Park, Victoria, Australia
    Posts
    90
    Thanks
    15
    Thanked 5 Times in 5 Posts
    [quote name='rory' post='774278' date='08-May-2009 23:12']I've added 2 UDFs to your file and used them in two additional columns (so you can check them against your figures!)[/quote]

    Rory,

    Thanks heaps - your UDFs will save me heaps of time as the spreadsheet in question had over 20,000 rows of data that I had to extract these figures from.

    Regards,
    Maria
    Maria
    Simmo7
    Victoria, Australia

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •