Excel Get text between two characters

0 votes

I'm trying to get the text between the last / and ' in the column below:

enter image description here

So that my answer will be:

enter image description here

I tried using the formulas:

=MID(A5, SEARCH("/", A5)+1, SEARCH("''", A5) - SEARCH("/", A5) -1)

and

=MID(RIGHT(A5,FIND("/",A5)-1),FIND("/",A5)+1,LEN(A5))

But unfortunately, they aren't working. 

Feb 14, 2023 in Others by narikkadan
• 63,680 points
625 views

1 answer to this question.

0 votes

Try this:

=SUBSTITUTE(TEXTAFTER(A1:A4,"/",-1),"'","")

Here is the output: excel output

Similarly to get the text before:

=SUBSTITUTE(TEXTBEFORE(A1:A4,"/",-1),"'","")
answered Feb 14, 2023 by Kithuzzz
• 38,020 points

Related Questions In Others

0 votes
1 answer

Excel formula for searching two text in one cell and return values based on the result

You can include a second IF within ...READ MORE

answered Oct 10, 2022 in Others by narikkadan
• 63,680 points
1,187 views
0 votes
1 answer

Excel get percentage of difference between numbers?

Find the percentage of change between two ...READ MORE

answered Nov 8, 2022 in Others by gaurav
• 23,260 points
741 views
0 votes
1 answer

Excel VLOOKUP between two sheets failing

Try this: =VLOOKUP(A2,'1'!$A$2:$E$811,5,0) I altered "1"! $A$2:$A$811 to '1'! ...READ MORE

answered Dec 13, 2022 in Others by narikkadan
• 63,680 points
650 views
0 votes
1 answer

Excel - count days between two dates per year

Put this in C2 and copy over: =MIN(DATE(C1,12,31),$B$2)-MAX(DATE(C ...READ MORE

answered Dec 29, 2022 in Others by narikkadan
• 63,680 points
489 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,690 points
3,842 views
0 votes
1 answer

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

Hi To Calculate the date, we can ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,690 points
1,947 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17, 2022 in Others by Edureka
• 13,690 points
953 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

answered Feb 18, 2022 in Others by gaurav
• 23,260 points
3,588 views
0 votes
1 answer

Excel formula to get certain cell if the value is between 2 numbers

So, first with vlookup(): A formula so you ...READ MORE

answered Feb 11, 2023 in Others by Kithuzzz
• 38,020 points
1,058 views
0 votes
1 answer

Get column index from table header in excel

Try it. The StaffDetailsTbl table's headers are ...READ MORE

answered Feb 23, 2023 in Others by Kithuzzz
• 38,020 points
746 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