how i can make it?

[SBAY3I]

hello all members
i got some problems in excel. one of them is i want to make
72653/m/17 like that ***53/m/17
101371/f/17 like that ****71/f/17
72673/m/17 like that ***73/m/17

 

[SBAY3I]

hello jtakw
https://1drv.ms/x/s!As8Mdv-a95REhTivKZr5Dz_GRFUP
in this link i upload the current excel, i try to change the excel language but i couldnt

First, I have No Idea what that says, I don't read that language.

Second, you need to change the Cell References in the formula to suit your data set.
I've done that in Post #16 , use formula in Post #16 .

 

[jtakw]

Which formula are you referring to?

The one in this thread, Post #16 , or your other thread "Formula speed in excel?" Post #7 ?

 

[SBAY3I]

your formula of speed its works with me but the other one not

 

[jtakw]

Take a look at your Excel On Line file, Column E, it works fine.

 

[SBAY3I]

great you did it man, thank you very much

Take a look at your Excel On Line file, Column E, it works fine.

 

[jtakw]

You're welcome, welcome to the forum.