Extracting data after SECOND dash

[Bryan M. Bolin]

I'm not sure if this is possible, or how difficult it could be, but I
have a user needing to extract some data from a column consisting of
part descriptions. The data shows as: "159-RM1-568 Bright Red".
What they need is for one column to have just "159-RM1". The second
column just needs the "568" part after the second dash.
The main problem I'm having is getting it to pull the data after the
second dash. The part descriptions aren't consistent, but do all have
"xx-xxx-xx", "xxx-xx-xxx" or "xxx-xxx-xxx" at the beginning.
Any assistance would be GREATLY appreciated!

Thanks!

Bryan

 

[Niek Otten]

Hi Bryan,

=RIGHT(A1,LEN(A1)-SEARCH("-",A1,SEARCH("-",A1)+1))

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel