Bank Reference Number

[Shabbo]

Dear Sir,
I wanted to put after first – and before end of first – in column H
Data is large I can’t put all, but I wanted get data in column H after first - Number-
Please note that length different for all reference number so I cant use length formula.

 

[Chihiro]

There are few ways to accomplish this.

1. Using FILTERXML
=FILTERXML("<A><B>"&SUBSTITUTE(C3,"-","</B><B>")&"</B></A>","//A/B[2]")

2. Using Substitute & Rept
=TRIM(MID(SUBSTITUTE(C3,"-",REPT(" ",99)),99,99))

There are more, but above 2 are probably the easiest.