Sort.....

[Guest]

Hi all,
I have data in A column as follows

xddlstrpm.p
xddostup.p
xddpabs.i
xddpchk1.i
xddpcl.i
xddpclmt.p
xddpexmt.p
xddpflpr.p
xddpflprt.p
xddpfrmt.p
xddpgprp.p
xddpilc2.i
xddplsc1.i
xddplsc2.i
xddplsck.i

here i wolud like all the extenctions ends with .i to be filled in column B
any help..

 

[Guest]

I don't know if this wil do all you want, but
in B1 enter
=if(right(A1,1)="i",A1,"")
and copy down to the bottton of your data.