Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Jul 2006
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I need to amend this formula: =TRIM(LEFT(E2,(FIND(" ",E2))))

    So that it is able to remove any spaces from the begining and then only show the number before the text
    In the atatchment l require the number 124.406 to be shown in the yellow cell highlighted.
    Any help would be appreciated.
    Attached Files Attached Files

  2. #2
    2 Star Lounger
    Join Date
    Aug 2004
    Posts
    123
    Thanks
    0
    Thanked 1 Time in 1 Post
    Quote Originally Posted by jj1972 View Post
    I require the number 124.406 to be shown in the yellow cell highlighted.
    Try, F2

    =LEFT(TRIM(E2),FIND(" ",TRIM(E2)))

    Regards
    Bosco

  3. #3
    4 Star Lounger
    Join Date
    Jul 2006
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts
    thats great many thanks

  4. #4
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    Quote Originally Posted by jj1972 View Post
    thats great many thanks
    NOTE, that IF FIND does NOT find a SPACE it would generate a VALUE ERROR in the Formula.
    If there are Ones with NO Space you might need to Wrap the FIND in an IF.
    Andrew

Posting Permissions

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