Eriktoinfinity
New Member
- Joined
- Apr 1, 2014
- Messages
- 6
I know you technically can't have numbers AND text in a cell but let's say I have the following cells in the first column:
<tbody>
</tbody>
And I want to pull the 3 leftmost characters into the next column only if they are numbers (as shown). Is that possible?
Related to this is I want it to convert them to a number so there are no leading "0"s.
I created a very basic macro that pulled back numbers and then "paste special - values" to get rid of the formulas, but the leading "0"s stayed and I can't get rid of them even when I select them and convert to number through right-clicking and "Format Cells". Any help would be appreciated.
004 BRD HSE | 004 |
PLT BRD SD | |
040 RPL CUS | 040 |
<tbody>
</tbody>
And I want to pull the 3 leftmost characters into the next column only if they are numbers (as shown). Is that possible?
Related to this is I want it to convert them to a number so there are no leading "0"s.
I created a very basic macro that pulled back numbers and then "paste special - values" to get rid of the formulas, but the leading "0"s stayed and I can't get rid of them even when I select them and convert to number through right-clicking and "Format Cells". Any help would be appreciated.