Need Formula For Extracting Part Numbers
On 5/31/2016 at 2:50:17 PM tb wrote:
I am using Excel 2010 for Windows.
I have a database of part numbers like this one:
10_32M2A050A002 CYLINDER
Please note that there are two blank spaces between "32M2A050A002" and
"CYLINDER".
I need a formula that will extract each string after the unerscore (_)
sign and the two blank spaces.
So the end result would be this:
32M2A050A002
Thanks for your help.
Thank you Auric__ and Claus.
--
tb
|