Extracting data after SECOND dash

  • Thread starter Thread starter Bryan M. Bolin
  • Start date Start date
B

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
 
Hi Bryan,

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Back
Top