muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,077
- Office Version
- 365
- 2021
- Platform
- Windows
hello all,
i need formula to delete extra spaces and adding/insert zero number (00) in between,
my text/string is 12 digits number
for example :
<tbody>
</tbody>
thanks for your help....
i need formula to delete extra spaces and adding/insert zero number (00) in between,
my text/string is 12 digits number
for example :
sample | expected result |
2006 10 2801 | 200610002801 |
2003 08 0074 | 200308000074 |
etc |
<tbody>
</tbody>
thanks for your help....