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

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

Path	csiph.com!aioe.org!eternal-september.org!feeder.eternal-september.org!mx02.eternal-september.org!.POSTED!not-for-mail
From	Claus Busch <claus_busch@t-online.de>
Newsgroups	microsoft.public.excel.programming
Subject	Re: Extracting numbers greater than 5 digits from a string (variable position)
Date	Wed, 22 Jul 2015 07:39:11 +0200
Organization	A noiseless patient Spider
Lines	26
Message-ID	<mona7a$ea8$1@dont-email.me> (permalink)
References	<ae7sqatilhkvr7n9b6dn5rj6f00qb7sdtu@4ax.com> <molboc$l66$1@dont-email.me> <mollnh$s30$1@dont-email.me> <stdtqal5oeqfjh2f6fade1l97tusooojmc@4ax.com>
Mime-Version	1.0
Content-Type	text/plain; charset="iso-8859-1"
Content-Transfer-Encoding	8bit
Injection-Date	Wed, 22 Jul 2015 05:37:46 +0000 (UTC)
Injection-Info	mx02.eternal-september.org; posting-host="03dd6e19f9b4d55bcd382d763c1f8835"; logging-data="14664"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX19ecWIsP7Hd9JZq0FjtFiOoXcXcd0Z/vlo="
User-Agent	40tude_Dialog/2.0.15.84de (f931c70f.479.509)
Cancel-Lock	sha1:OFHZvgxoRjlcLgzPOyUx52qihSE=
Xref	aioe.org microsoft.public.excel.programming:107869

Show key headers only | View raw

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

Back to microsoft.public.excel.programming | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

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

csiph-web