Results 1 to 6 of 6

extract and sum numbers from a text string

Threaded View

Shazwb extract and sum numbers from... 08-28-2011, 08:09 PM
scottylad2 Re: Formula help required 08-28-2011, 08:13 PM
scottylad2 Re: extract and sum numbers... 08-28-2011, 08:40 PM
rwhidden Re: extract and sum numbers... 08-28-2011, 08:52 PM
Shazwb Re: extract and sum numbers... 08-28-2011, 09:24 PM
Shazwb Re: Formula help required 08-28-2011, 08:32 PM
  1. #1
    Registered User
    Join Date
    08-28-2011
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003
    Posts
    3

    extract and sum numbers from a text string

    Hi

    This is my first time posting - so I hope I've picked the correct section to ask for help.....

    I have three cells containing the following information;

    CLY-7.5 CLY-5.0 CLY-2.0

    Sometimes the text string will change, however there will always be a dash and then one number with one decimal point at the end ie;
    LSL-5.0 or A/L-6.3 or CLN-4.5 etc...

    I would like a formula that will calculate 7.5 + 5 + 2 = 14.5

    Can anyone please help?

    Many thanks
    Last edited by Shazwb; 08-28-2011 at 08:28 PM. Reason: title was not clear enough

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