Substring Find last occurence of and output everything to the right of it

0 votes

I want to use a formula that will output everything to the right of the final instance of the forward slash character (/) after it is located. Here's an illustration:

/shared/Custom/Conversion_Reports/Supplier Address/Supplier Address Rejection.xdo

To print everything to the right of the last slash in this example, which is the fifth one above (counting from left to right), I would type Supplier Address Rejection.xdo.

I need to use some sort of locate function because the folder names all have varied lengths and there are different numbers of folders (slashes), but I'm not sure how to discover the final instance of a particular character. I appreciate it.

Mar 23, 2023 in Others by Kithuzzz
• 38,010 points
290 views

1 answer to this question.

0 votes

Use TEXTAFTER() Function:

=TEXTAFTER(B2,"/",-1)
answered Mar 23, 2023 by narikkadan
• 63,420 points

Related Questions In Others

0 votes
2 answers
0 votes
1 answer

How to find the time complexity of a program?

Hi@akhtar, The first loop is O(N) and the ...READ MORE

answered Oct 15, 2020 in Others by MD
• 95,440 points
973 views
–1 vote
0 answers
0 votes
1 answer

INDEX formula in Excel, Top 10, repeats previous value

Try this formula in cell W4: =IF(V3=V4,INDEX(INDIRECT("I"&MATCH(W3,I:I,0)+1&":I26"),MATCH(V4,INDIRECT("R"&MATCH(W3,I:I,0)+1&":R26"),0)),INDEX($I$2:$I$26,MATCH(V4,$R$2:$R$26,0))) The calculation ...READ MORE

answered Oct 8, 2022 in Others by narikkadan
• 63,420 points
576 views
0 votes
1 answer

Mapping cells between between two ranges

Try this: =IF(B4:H10<>"",B14:H20,"") READ MORE

answered Mar 27, 2023 in Others by narikkadan
• 63,420 points
432 views
0 votes
2 answers

How to copy a formula horizontally within a table using Excel VBA?

Hi so basically, create an adjacent column ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,670 points
691 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,670 points
1,030 views
0 votes
1 answer
0 votes
1 answer

How to hide and unhide the columns of an excel sheet using asp.net

Use this. For Row: worksheet_sub.Row(i).Height = 0; For Column: ...READ MORE

answered Oct 29, 2022 in Others by narikkadan
• 63,420 points
1,228 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP