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]

i couldnt. i try many time without result

 

[SBAY3I]

https://1drv.ms/u/s!As8Mdv-a95REhTODZr_h6ibR_dBQ
i succes

 

[jtakw]

You only uploaded a picture...

Looks like you have trailing spaces in Column H, how did these values get into Column H, enter manually, by formula, or imported?

You may also upload a sample file.

Also, do you want to replace the formula in E8? or have a formula for another Column?

 

[SBAY3I]

i got these value into column H, by importation.
yeah i want to replace the formula in E8.
if the formula doesnt work with column E8 its ok to replaced for another column

 

[jtakw]

Assuming those are Real trailing spaces in Column H, Not some "hidden" characters and/or "unbreakable space"

Put this in E8 copied down:

Book1
	E	F	G	H	I
1	***53/M/17		17	72653	M
Sheet137

Cell Formulas
Range	Formula
E1	=REPT("*",LEN(TRIM(H1))-2)&RIGHT(TRIM(H1),2)&"/"&I1&"/"&G1

 

[jtakw]

Assuming those are Real trailing spaces in Column H, Not some "hidden" characters and/or "unbreakable space"

Put this in E8 copied down:

Book1
	E	F	G	H	I
1	***53/M/17		17	72653	M
Sheet137

Cell Formulas
Range	Formula
E1	=REPT("*",LEN(TRIM(H1))-2)&RIGHT(TRIM(H1),2)&"/"&I1&"/"&G1

Cell references changed for row 8:

Formula in E8 copied down.

Book1
	E	F	G	H	I
8	***53/M/17		17	72653	M
Sheet137

Cell Formulas
Range	Formula
E8	=REPT("*",LEN(TRIM(H8))-2)&RIGHT(TRIM(H8),2)&"/"&I8&"/"&G8

 

[SBAY3I]

hello
https://1drv.ms/u/s!As8Mdv-a95REhTZZwqWQmFF7knxA

 

[jtakw]

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]

NOTE: you'll probably need to change the Functions in the correct Language for your Excel.

 

[SBAY3I]

thank you for all your helps