Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #107869 > unrolled thread

Re: Extracting numbers greater than 5 digits from a string (variable position)

Back to article view | Back to microsoft.public.excel.programming

This discussion starts older than the indexed window; earlier articles aren't shown. The article labeled Started by below is the oldest one visible, not the original post.

Contents

  Re: Extracting numbers greater than 5 digits from a string (variable position) Claus Busch <claus_busch@t-online.de> - 2015-07-22 07:39 +0200
    Re: Extracting numbers greater than 5 digits from a string (variable position) Phrank <pbeal@hotmail.com> - 2015-07-24 08:13 -0400
      Re: Extracting numbers greater than 5 digits from a string (variable position) Claus Busch <claus_busch@t-online.de> - 2015-07-24 15:17 +0200

#107869 — Re: Extracting numbers greater than 5 digits from a string (variable position)

Hi Frank,

Am Tue, 21 Jul 2015 17:30:57 -0400 schrieb fdb_biz@bloomingdalecom.net:

> So, it seems it would be a straight forward solution.  But there's
> something with the formatting of the Product Numbers after being
> extracted via the code below that errors out (#NA) the vlookup
> formula.  I've tried copy/pasting the column as text, as general, as
> number, and doing the same to the numbers on Sheet2, to no avail.  If
> I take the exact same number on Sheet2 and paste it over the number on
> Sheet1, then the formula works.  The Product Number doesn't APPEAR to
> change at all.  But it does.  Any thoughts on that?  If I can't get
> the product description, it's not the end of the world - this code
> below gets me to where the users most basically need to be.  But it
> would be helpful to be able to add the description.  

check the Product Number in sheet2 for leading or trailing spaces and
delete them with TextToColumns => Fixed Width => Finish.
If that is not the solution please provide some examples.


Regards
Claus B.
-- 
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

[toc] | [next] | [standalone]

#107876

That did the trick.  All is well, and the thing works great!  This was
a key piece to the puzzle.  This project will now be almost
universally accepted by everyone because they can incorporate most of
their old methods with the new methods.  Thanks so much!!

Frank

On Wed, 22 Jul 2015 07:39:11 +0200, Claus Busch
<claus_busch@t-online.de> wrote:

>Hi Frank,
>
>Am Tue, 21 Jul 2015 17:30:57 -0400 schrieb fdb_biz@bloomingdalecom.net:
>
>> So, it seems it would be a straight forward solution.  But there's
>> something with the formatting of the Product Numbers after being
>> extracted via the code below that errors out (#NA) the vlookup
>> formula.  I've tried copy/pasting the column as text, as general, as
>> number, and doing the same to the numbers on Sheet2, to no avail.  If
>> I take the exact same number on Sheet2 and paste it over the number on
>> Sheet1, then the formula works.  The Product Number doesn't APPEAR to
>> change at all.  But it does.  Any thoughts on that?  If I can't get
>> the product description, it's not the end of the world - this code
>> below gets me to where the users most basically need to be.  But it
>> would be helpful to be able to add the description.  
>
>check the Product Number in sheet2 for leading or trailing spaces and
>delete them with TextToColumns => Fixed Width => Finish.
>If that is not the solution please provide some examples.
>
>
>Regards
>Claus B.

[toc] | [prev] | [next] | [standalone]

#107877

Hi Frank,

Am Fri, 24 Jul 2015 08:13:01 -0400 schrieb Phrank:

> That did the trick.  All is well, and the thing works great!  This was
> a key piece to the puzzle.  This project will now be almost
> universally accepted by everyone because they can incorporate most of
> their old methods with the new methods.  Thanks so much!!

always glad to help. Appreciate your feedback.


Regards
Claus B.
-- 
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

[toc] | [prev] | [standalone]

Back to top | Article view | microsoft.public.excel.programming

csiph-web