strongman86
Board Regular
- Joined
- Feb 15, 2017
- Messages
- 115
- Office Version
- 2019
- Platform
- Windows
Lads,
i have formula in cell A2: ''=LEFT(A1,4)&RIGHT(A1,4)+1'' that increments next cell by 1. Problem is when number go over 1000 it looks like this: HMR01000, but I need it to be HMR1000 , HMR1001 etc.
<tbody>
</tbody>
Thanks.
i have formula in cell A2: ''=LEFT(A1,4)&RIGHT(A1,4)+1'' that increments next cell by 1. Problem is when number go over 1000 it looks like this: HMR01000, but I need it to be HMR1000 , HMR1001 etc.
A | |
1 | HMR0500 |
2 | HMR0501 |
<tbody>
</tbody>
Thanks.