Excel How to grab value in cell between two slashes

Asked Nov 04 '21 at 15:47

Active Nov 04 '21 at 15:48

Viewed 161 times

I have a problem of writing a right formula for this cell extraction.

My cell looks like this :

RED123/GREEN BLUE/543287-R231D321D/12345678910/0987654321.

I need to extract 543287-R231D321D this value from a cell.

Tried to get some samples from other topics but didn't worked.

Thanks for everyone's help.

edited Nov 04 '21 at 15:48

Scott Craner

asked Nov 04 '21 at 15:47

Mindaugas Vilimas

1

If you have FILTERXML: https://stackoverflow.com/questions/61837696/excel-extract-substrings-from-string-using-filterxml – Scott Craner Nov 04 '21 at 15:49
IF not: `=TRIM(MID(SUBSTITUTE(A1,"/",REPT(" ",999)),999*2,999))` – Scott Craner Nov 04 '21 at 15:50
You can use the commands in excel "Left" and "Right" An example to get the left part of the cell: =LEFT(A1,FIND("-", A1)-1) – Peres Nov 04 '21 at 15:53
Thanks @ScottCraner ! Problem was solved with formula =TRIM(MID(SUBSTITUTE(A1,"/",REPT(" ",999)),999*2,999)) – Mindaugas Vilimas Nov 04 '21 at 16:13

0 Answers0