Carpe Diem wrote:
Hi,

I have the following data in a table:
0200CO100701
0200CO1007011
0200/72100001

And I woold like to choose only the rows thata as "/" in this column
(in this example the third number), and give me only the value
"72100001"

Thank you.


Something like this works:

=MID(A3;FIND("/";A3)+1;LEN(A3)-FIND("/";A3))

CoRrRan
-----------
Change NOSPAM to GMAIL