Noobllianz
New Member
- Joined
- Jul 1, 2018
- Messages
- 18
Hi Guys.
Could really use the help.
<tbody>
</tbody>
Basically, I will copy paste item prices from a sales sheet onto a blank sheet.
The maximum length of a number can only be 8 digits. Any numbers that are not 8 digits need a _ in front or back of the number if possible.
e.g , b1 = __100000 or 100000__
b2 = ___20000 or 20000___
c1 = _____100 or 100_____
c2 = ______20 or 20______
Is there any way to do this? If the numbers were consistant, i would use concatnate to add _ to the numbers, however it is unstructured.
Appreciate the help!
Thanks.
-b
Could really use the help.
a | b | c | d | |
1 | item 1 | 100000 | 100 | 10000000 |
2 | item 2 | 20000 | 20 | 20000000 |
3 | item 3 | 30000 | 3000 | 30000000 |
4 | item 4 | 4000 | 400 | 40000000 |
<tbody>
</tbody>
Basically, I will copy paste item prices from a sales sheet onto a blank sheet.
The maximum length of a number can only be 8 digits. Any numbers that are not 8 digits need a _ in front or back of the number if possible.
e.g , b1 = __100000 or 100000__
b2 = ___20000 or 20000___
c1 = _____100 or 100_____
c2 = ______20 or 20______
Is there any way to do this? If the numbers were consistant, i would use concatnate to add _ to the numbers, however it is unstructured.
Appreciate the help!
Thanks.
-b