muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,077
- Office Version
- 365
- 2021
- Platform
- Windows
hi all.
i,m looking for a formula in Custom Number Format to make series number with text like this:
anyone give me figure out this problem, thank in advance
susant
i,m looking for a formula in Custom Number Format to make series number with text like this:
Book1 | ||||
---|---|---|---|---|
D | E | |||
3 | data given | expected result | ||
4 | frans | 1) frans | ||
5 | deta | 2) deta | ||
6 | qimo | 3) qimo | ||
7 | johny | 4) johny | ||
8 | merry | 5) merry | ||
9 | 1) frans | |||
10 | 2) deta | |||
11 | 3) qimo | |||
12 | 4) johny | |||
13 | 5) merry | |||
14 | 1) frans | |||
15 | 2) deta | |||
16 | 3) qimo | |||
17 | 4) johny | |||
18 | 5) merry | |||
Sheet1 |
anyone give me figure out this problem, thank in advance
susant