Extracting from a cell based on a character that is in the cell multiple times

[lwilt]

If i have "" that symbol multiple times within the cell but I want to pull everything right of the last "" how would I do that.


example: thehappy_housegrey.jpeg

basketballnbatitlethebostonceltics.jpeg

 

[oldchippy]

Hi lwilt,


Take a look here


http://chandoo.org/wp/tag/text-to-columns/

 

[jeffreyweir]

OR if you don't want to manually use text-to-columns, you could use this on text that was in A1:

=MID(A1,1+FIND("|",SUBSTITUTE(A1,"","|",LEN(A1)-LEN(SUBSTITUTE(A1,"","")))),LEN(A1))