Results 1 to 22 of 22

Searching value of specific length

Threaded View

Marco-Kun Searching value of specific... 12-01-2011, 07:16 AM
StephenR Re: Searching value of... 12-01-2011, 07:47 AM
Marco-Kun Re: Searching value of... 12-01-2011, 07:55 AM
StephenR Re: Searching value of... 12-01-2011, 07:57 AM
Marco-Kun Re: Searching value of... 12-01-2011, 08:20 AM
StephenR Re: Searching value of... 12-01-2011, 08:35 AM
Marco-Kun Re: Searching value of... 12-01-2011, 08:54 AM
Marco-Kun Re: Searching value of... 12-01-2011, 09:08 AM
snb Re: Searching value of... 12-06-2011, 08:11 AM
StephenR Re: Searching value of... 12-01-2011, 10:27 AM
Marco-Kun Re: Searching value of... 12-01-2011, 10:39 AM
StephenR Re: Searching value of... 12-01-2011, 10:45 AM
nilem Re: Searching value of... 12-01-2011, 11:00 AM
Marco-Kun Re: Searching value of... 12-01-2011, 11:35 AM
StephenR Re: Searching value of... 12-01-2011, 01:45 PM
Marco-Kun Re: Searching value of... 12-06-2011, 07:49 AM
nilem Re: Searching value of... 12-06-2011, 10:56 AM
Marco-Kun Re: Searching value of... 12-06-2011, 11:23 AM
  1. #1
    Forum Contributor Marco-Kun's Avatar
    Join Date
    04-14-2009
    Location
    Holland
    MS-Off Ver
    Dutch:2007
    Posts
    298

    Searching value of specific length

    Hello everyone,

    I have the following question:

    In a workbook I have a few rows looking like this:

     LISDFGSD CD                          SDGSDFGSDFPLEIN 33 A 3445 EP ROTT 21555                         210521/MIV 16-3-2010/DJ
    
     DEBI 213405             IAS        PLEINPLEIN 21 B 30e5 EP ROTT 18112825
    There are lots of spaces, not consistent at all. Lets say the first line is A1 and the second A2. What I need is a formula in the cell next to these two lines that give me the following values:
    For A1: 210521
    For A2: 213405

    The formula has to subtract a number which is always 6 digits long, starting with "21". It can be anywhere in the cell.

    I hope I'm clear enough explaining this!

    Thanks in advance,

    Marco

    Edit: SOLVED
    Last edited by Marco-Kun; 12-06-2011 at 11:24 AM.

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