Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,872
Default Extraction of Part Numbers from Text Strings

Hi again,

Am Sat, 9 May 2020 08:55:47 -0500 schrieb tb:

Unfortunately our parts have different descriptions...


download the workbook from he
https://1drv.ms/x/s!AqMiGBK2qniTget2...1YHlA?e=4is9jJ

and check out if the formulas or the function will work for you.


Regards
Claus B.
--
Windows10
Office 2016
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tb tb is offline
external usenet poster
 
Posts: 84
Default Extraction of Part Numbers from Text Strings

On 05/09/2020 10:09 AM, Claus Busch wrote:
Hi again,

Am Sat, 9 May 2020 08:55:47 -0500 schrieb tb:

Unfortunately our parts have different descriptions...


download the workbook from he
https://1drv.ms/x/s!AqMiGBK2qniTget2...1YHlA?e=4is9jJ

and check out if the formulas or the function will work for you.


Regards
Claus B.


The link sends me to a page indicating that the item might not exist or
is no longer available.
--
tb

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,872
Default Extraction of Part Numbers from Text Strings

Hi,

Am Sat, 9 May 2020 11:39:55 -0500 schrieb tb:

The link sends me to a page indicating that the item might not exist or
is no longer available.


for me the link works fine. Try it again.


Regards
Claus B.
--
Windows10
Office 2016
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tb tb is offline
external usenet poster
 
Posts: 84
Default Extraction of Part Numbers from Text Strings

On 05/09/2020 11:56 AM, Claus Busch wrote:
Hi,

Am Sat, 9 May 2020 11:39:55 -0500 schrieb tb:

The link sends me to a page indicating that the item might not exist or
is no longer available.


for me the link works fine. Try it again.


Regards
Claus B.


It does not seem to work for me...

The link redirects to

<https://onedrive.live.com/view.aspx?resid=9378AAB6121822A3!30198&ithint=file %2cxlsx&wdo=2&authkey=!ABaDwYtn1u9WB5Q

....and it tells me that "This item might not exist or is no longer
available".
--
tb

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,872
Default Extraction of Part Numbers from Text Strings

Hi,

Am Sat, 9 May 2020 12:53:09 -0500 schrieb tb:

It does not seem to work for me...

The link redirects to

<https://onedrive.live.com/view.aspx?resid=9378AAB6121822A3!30198&ithint=file %2cxlsx&wdo=2&authkey=!ABaDwYtn1u9WB5Q

...and it tells me that "This item might not exist or is no longer
available".


send me an email. I send you the workbook via email.


Regards
Claus B.
--
Windows10
Office 2016


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Capturing Part Numbers Within Text Strings tb Excel Worksheet Functions 2 May 2nd 19 02:01 PM
Help With Searching For Strings In Part Numbers tb Excel Worksheet Functions 3 June 21st 11 04:22 PM
VBA extraction of a part of the cells content Jack Sons Excel Discussion (Misc queries) 1 April 27th 10 10:58 PM
2 more questions about extracting numbers from text strings andy from maine Excel Discussion (Misc queries) 0 March 28th 05 09:47 PM
Text strings recognized as numbers given different regional settin Anders Excel Programming 0 September 8th 04 11:03 PM


All times are GMT +1. The time now is 10:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"