+ Reply to Thread
Results 1 to 3 of 3

nesting len , right and left functions.

  1. #1
    Registered User
    Join Date
    01-20-2012
    Location
    Lancashire,England
    MS-Off Ver
    Office 2007
    Posts
    11

    nesting len , right and left functions.

    Hi all,

    I am struggling to nest the len, right and left functions.

    I paste external data into cell a1 "2 Adults, 4 Children"

    In cell b1 I would like to return 4 as a number (that is the number of children)

    i.e. remove the word "[space] Children" and remove "2 [space] Adults" keeping the number value 4.

    Thanks for any help.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: nesting len , right and left functions.

    Here, try this:

    =LOOKUP(99^99,--LEFT(TRIM(MID(A1,FIND(",",A1)+1,100)),ROW($A$1:$A$5)))

    Edit: Must be , in the word as in the example

  3. #3
    Registered User
    Join Date
    01-20-2012
    Location
    Lancashire,England
    MS-Off Ver
    Office 2007
    Posts
    11

    Re: nesting len , right and left functions.

    Absolutely blistering speed of reply and perfect result. Thankyou so much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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