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

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

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

Show all headers | 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