Stormrider2230
New Member
- Joined
- Dec 3, 2021
- Messages
- 5
- Office Version
- 2016
- Platform
- Windows
Hi all,
I need help in trimming selected cells, from right, so that only first 14 characters (numbers) remain.
I have column filled with numbers but some of them have additional characters at the end so in total there are 14-18 or more numbers.
They are all numerical.
I need VBA that will keep the cell unchanged if there is only 14 numbers in it, or less, and if there are more, it will trim from the right, so only first 14 numbers will remain (or less if there are less).
I prefer it is done via selected cells.
I don't have any examples. I am very new in this. Don't quite understand variables to be able to apply similar solutions I found.
I need help in trimming selected cells, from right, so that only first 14 characters (numbers) remain.
I have column filled with numbers but some of them have additional characters at the end so in total there are 14-18 or more numbers.
They are all numerical.
I need VBA that will keep the cell unchanged if there is only 14 numbers in it, or less, and if there are more, it will trim from the right, so only first 14 numbers will remain (or less if there are less).
I prefer it is done via selected cells.
I don't have any examples. I am very new in this. Don't quite understand variables to be able to apply similar solutions I found.