Return value from string after "\"

[Access Beginner]

Hello,



I have a file path in cell D11 R:\ABC\AIS\GREM\DATA_NSO\Data\Dashboard Reports\Region1\ and I would like to return the value of Region1.

Can someone please assist?

 

[Teeroy]

Try the formula:

=TRIM(MID(SUBSTITUTE(D11,"\",REPT(" ",100)),(LEN(D11)-LEN(SUBSTITUTE(D11,"\",""))-1)*100,32767))

Note that this will depend on having the trailing "" as you've advised.

HTH.

 

[Access Beginner]

thanks exactly what I was after.

 

[jtakw]

Hi,

How about this:

Book1
	D
11	R:\ABC\AIS\GREM\DATA_NSO\Data\Dashboard Reports\Region1\
12	Region1
Sheet193

Cell Formulas
Range	Formula
D12	=TRIM(RIGHT(SUBSTITUTE(D11,"",REPT(" ",255)),510))