I'm trying to get the text between the last / and ' in the column below: So that my answer will be: 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 in Others 63 views

## 1 answer to this question.

Try this:

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

Here is the output: Similarly to get the text before:

`=SUBSTITUTE(TEXTBEFORE(A1:A4,"/",-1),"'","")`
• 34,760 points

## 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

## Excel get percentage of difference between numbers?

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

## 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

## 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

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

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

## Convert Rows to Columns with values in Excel using custom format

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

## IF - ELSE IF - ELSE Structure in Excel

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