Capturing Part Numbers Within Text Strings
 

I need to capture part numbers that are embedded in text strings.

For instance, the string in A1 is:

9UNI01 05A4462-300202 US1U US1C Standard

....and I am looking for a function (in B1) that will capture the part
number, i.e.:

05A4462-300202

The part numbers are always in the second position of a string and
separated --right and left of them-- by several blank characters.

Thanks.
--
tb

Capturing Part Numbers Within Text Strings
 

Hi,

Am Wed, 1 May 2019 16:40:28 +0000 (UTC) schrieb tb:

I need to capture part numbers that are embedded in text strings.

For instance, the string in A1 is:

9UNI01 05A4462-300202 US1U US1C Standard

...and I am looking for a function (in B1) that will capture the part
number, i.e.:

05A4462-300202

The part numbers are always in the second position of a string and
separated --right and left of them-- by several blank characters.

try:

=LEFT(TRIM(MID(A1,FIND(" ",A1),99)),FIND(" ",TRIM(MID(A1,FIND(" ",A1),99))))


Regards
Claus B.
--
Windows10
Office 2016

Capturing Part Numbers Within Text Strings
 

On 5/1/2019 at 12:04:29 PM Claus Busch wrote:

Hi,

Am Wed, 1 May 2019 16:40:28 +0000 (UTC) schrieb tb:

I need to capture part numbers that are embedded in text strings.

For instance, the string in A1 is:

9UNI01 05A4462-300202 US1U US1C Standard

...and I am looking for a function (in B1) that will capture the
part number, i.e.:

05A4462-300202

The part numbers are always in the second position of a string and
separated --right and left of them-- by several blank characters.

try:

=LEFT(TRIM(MID(A1,FIND(" ",A1),99)),FIND(" ",TRIM(MID(A1,FIND("
",A1),99))))


Regards
Claus B.

Thanks, Claus!

--
tb