Hello,
I have some cells with different variations of numbers and letters (always 4 characters though)
For example:
E357
0010
I303
T303
0150
what i need to do (if possible) in a non VBA way is:
In the cell next to where this data is i want the same information but if there are zeros at the beginning then i want the deleted from the cell.
So, for example T303 should stay the same because there is something other than a 0 in front of it
but 0150 should become 150 and 0010 should become 10
Is this possible?
Thanks in advance if anyone can answer this.
I have some cells with different variations of numbers and letters (always 4 characters though)
For example:
E357
0010
I303
T303
0150
what i need to do (if possible) in a non VBA way is:
In the cell next to where this data is i want the same information but if there are zeros at the beginning then i want the deleted from the cell.
So, for example T303 should stay the same because there is something other than a 0 in front of it
but 0150 should become 150 and 0010 should become 10
Is this possible?
Thanks in advance if anyone can answer this.