+ Reply to Thread
Results 1 to 8 of 8

Delete numbers in cell

Hybrid View

  1. 06-21-2012, 05:17 AM #1
    npamcpp
    npamcpp is offline
    Valued Forum Contributor
    Join Date
    04-30-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    547

    Re: Delete numbers in cell

    what about

    TUI AG V/R /PERP/EUR/

    there's no % sign. Is that the name then? Or is it TUI? Or TUI AG?

    My point is, there will probably not be a formula, since it's almost impossible to describe the logic. One has to be familiar with the brand names to recognise where a company name ends.
    Like a post? Click the star below it!
    Reply With QuoteRegister To Reply
  2. 06-21-2012, 06:49 AM #2
    Solrick
    Solrick is offline
    Registered User
    Join Date
    06-21-2012
    Location
    The Hague
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Delete numbers in cell

    Thanks for the help everybody but I think i have found the best possible solution.
    I have searched with FIND function for the first number to appear. Then with LEFT function I get the correct name in 99% of the cases, except for the ones you mention above.

    But anyway,
    thanks for the help
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1