If char help

[#1]

hi

in excel sheet in a column [Ticked_Id] i have 5 different type od data

1)   0

2)   C /CNL FEE

3)   F16071

4)   F16071/0000000241

5)   FF16071 /0000000141 24A20

first three (1,2,3 ) wont change

but  at last two (4,5) i want the code after "/" as 10 character  (0000000241)

at (4)  "/" is 7th character; at (5) "/" is 9th character after space.

how i can write this in is statement.

thanks

[#2]

thank you very much

[Jason_Michaelides]

We got there in the end 😉

[#4]

i used to REPLACE function to delete spaces and i used your staement in IF staement, the problem is solved.

Thank you very much. i learnt a lot of new things from you.

Best regards

[Jason_Michaelides]

No problem.  If you have lots of exceptions consider using ApplyMap() instead of lots of nested IFs.