Get the Last String value of n length after a delimiter from string using excel formula

Question

I need to get the last split value from the cell.

The input cell C1 value = main\java\com\tms\vsc\ppo\data\domain\Ppo.java

which must be copied to another cell B1 Expected output in B1 is Ppo.java

Below is the formula tried over in cell B1

=RIGHT(RIGHT(C1,FIND("\",C1)),256)

and

=RIGHT(C1,FIND("\",C1))

Can anyone help me out. Its a pure excel and not VBA

score 0 · Answer 1 · edited May 23 '17 at 12:23

0

=RIGHT(A1,LEN(A1)-FIND("|",SUBSTITUTE(A1,"\","|", LEN(A1)-LEN(SUBSTITUTE(A1,"\","")))))

Note that you must guarantee that your cell does not contain the character |

edited May 23 '17 at 12:23

Community

answered Dec 09 '15 at 07:15

romar

score 0 · Accepted Answer · edited Dec 09 '15 at 08:37

0

You can also use:

=TRIM(RIGHT(SUBSTITUTE(A1,"\",REPT(" ",LEN(A1))),LEN(A1)))

edited Dec 09 '15 at 08:37

agold

answered Dec 09 '15 at 07:21

XOR LX

2 Answers2