I need to extract part numbers from text strings that look like this:
Example 1:
J72 5-40 SOLENOID VALVE (there is a double space between J72
and SOLENOID)
Example 2:
SOLENOID VALVE K77 8-32 (there is a double space between VALVE
and K77)
Example 3:
SOLENOID VALVE _X37 1-22 X Y Z (there is an underscore before X37
and there are 2+ spaces between _X37 and whatever comes after that)
The formula that I am looking for would extract the part numbers as follows: Example 1: J72 5-40
Example 2: K77 8-32
Example 3: X37 1-22 (i.e. w/o the underscore and w/o whatever comes
after the 2+ spaces)
Hi,
Am Fri, 8 May 2020 20:49:06 -0500 schrieb tb:
I need to extract part numbers from text strings that look like this:
Example 1:
J72 5-40 SOLENOID VALVE (there is a double space between J72
and SOLENOID)
Example 2:
SOLENOID VALVE K77 8-32 (there is a double space between VALVE
and K77)
Example 3:
SOLENOID VALVE _X37 1-22 X Y Z (there is an underscore before X37
and there are 2+ spaces between _X37 and whatever comes after that)
The formula that I am looking for would extract the part numbers as follows: >> Example 1: J72 5-40
Example 2: K77 8-32
Example 3: X37 1-22 (i.e. w/o the underscore and w/o whatever comes
after the 2+ spaces)
if there is always "SOLENOID VALVE" into the string, try:
=LEFT(TRIM(SUBSTITUTE(SUBSTITUTE(A1,"SOLENOID VALVE",),"_",)),8)
Regards
Claus B.
Unfortunately our parts have different descriptions...
Unfortunately our parts have different descriptions...
Hi again,
Am Sat, 9 May 2020 08:55:47 -0500 schrieb tb:
Unfortunately our parts have different descriptions...
download the workbook from here: https://1drv.ms/x/s!AqMiGBK2qniTget2FoPBi2fW71YHlA?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.
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".
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.
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 307 |
Nodes: | 16 (2 / 14) |
Uptime: | 67:17:28 |
Calls: | 6,915 |
Files: | 12,379 |
Messages: | 5,431,811 |