ExcelBanter - text Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - text Formula (https://www.excelbanter.com/excel-programming/394261-text-formula.html)

Carpe Diem

text Formula

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.

CoRrRan[_2_]

text Formula

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

All times are GMT +1. The time now is 11:28 AM.