# Return everything after second underscore in a cell

#### heathclif

##### Board Regular
Cell A1:

blah_blah_everythingelsethatisinthiscell

Return:

everythingelsethatisinthiscell

Is there a MID FIND or anything else that will work?

Besame Much

### Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

#### Jonmo1

##### MrExcel MVP
Welcome to the board

Try

=REPLACE(A1,1,FIND("_",A1,FIND("_",A1)+1),"")

#### Mike LH

##### Well-known Member
Hi,

Try this

=MID(A1,FIND(CHAR(7),SUBSTITUTE(A1,"_",CHAR(7),2))+1,LEN(A1))

#### heathclif

##### Board Regular
Many thanks to both of you for your awesomeness!

You're welcome

#### Rick Rothstein

##### MrExcel MVP
Many thanks to both of you for your awesomeness!
If you are going to use Jonmo1's code (3 function calls to 6 for Mike's), and if you plan to copy it down where Column A's cells are blank (perhaps in anticipation of working against future data), then you might want to consider this version of it (returns "" instead of a #VALUE! error)...

=REPLACE(A1,1,FIND("_",A1&"__",FIND("_",A1&"_")+1),"")

Also, here is another formula (uses four function calls though) that will also work (assuming your text is less than 200 characters in length)...

=TRIM(MID(SUBSTITUTE(A1,"_",REPT(" ",200)),400,999))

#### heathclif

##### Board Regular
Hi Rick! Thanks for that!

Replies
1
Views
49
Replies
4
Views
111
Replies
8
Views
159
Replies
5
Views
206
Replies
5
Views
73

1,195,644
Messages
6,010,893
Members
441,571
Latest member
stolenweasel

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back