# how i can make it?

#### SBAY3I

##### New Member
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

### Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

#### welshgasman

##### Well-known Member
=rept("*",len(a1)-7)&right(a1,7)

#### jtakw

##### Well-known Member
Hi,

Another way, in case the length of characters are variable after the slash "/"

#### SBAY3I

##### New Member
thank you very much friends for your help
by the way the the colomn was in three colomn and i make them like that 72653/m/17
are your formulas can help me in this casse
****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
AB
172653/m/17***53/m/17
2101371/f/17****71/f/17
372673/m/17***73/m/17
472653/mf/17***53/mf/17
5101371/f/171****71/f/171
672673/mf/171***73/mf/171

</tbody>
</body>

#### jtakw

##### Well-known Member

Are you saying 72653/m/17 is in three separate columns Without the slash "/"?
So 72653 in A1, m in B1, 17 in C1?
And, you want the result to be ***53/m/17 in One Cell With the slash "/"?

#### SBAY3I

##### New Member
dosent works with me

#### mole999

##### Moderator

assume A1 for number then ="***" & RIGHT(A1,2)

#### SBAY3I

##### New Member
NO I MEAN 72653 WAS IN A1, AND M WAS IN B1, AND 17 WAS IN C1, AND I MAKE THEM IN ONE CELL LIKE 72653/M/17 WITH THIS FORMULA =A1&"/"&B1&"/"&C1
WHAT I WANT IS ***53/m/17 in One Cell With the slash "/" BUT I THINK THE FORMULA WHICH I PUT BEFOR BLOCKING YOURS =REPT("*",LEN(LEFT(A1,FIND("/",A1)-3)))&MID(A1,FIND("/",A1)-2,255)

#### jtakw

##### Well-known Member
Then do this:

D1 formula copied down.

Replies
10
Views
170
Replies
0
Views
33
Replies
5
Views
72
Replies
1
Views
30
Replies
6
Views
84

1,109,341
Messages
5,528,147
Members
409,804
Latest member
aceyus_michael

### This Week's Hot Topics

• Change military grades into rank
Afternoon all Need help with formula that will change military rank (i.e. 1, 2, 3 into Amn, A1C, SrA). Running IF formula that does not work...
• VBA COUNTIF SOLUTION
Hi The following are the errors spread across the several columns from E to Q ie. 13 columns across several sheets with more than 500 rows per...
• INSERT ROW WITH SPECIFIS TEXT IN A COLUMN
Hi All! How can identify that that the row to be inserted has to be inserted before 1st row with specific text in column F. If I record the...