I have several cells in a column where there could be 1, 2 or 3 "|" in the cell:

1093270| 29.03.2012|Mail opvragen Doc's

I just want him to look at the last "|" and give me everything that comes after the last |

i have at the moment this: (added 3 columns)

=MID(A1;FIND("|";A1)+1;150) </SPAN> | =IFERROR(MID(B1;FIND("|";B1)+1;150);B1)</SPAN> | =IFERROR(MID(C1;FIND("|";C1)+1;150);C1)</SPAN> |

<TBODY>

</TBODY>

(result is: Mail opvragen Doc's)

it does the trick, but i prefer one formula so i don't have to add them.

Does anyone know a better way then this?

Kind regards,

Les