sllaksvb
12-12-2017, 08:11 AM
Hi all,
I'm having trouble with creating the code for the left function in VBA.
What I am trying to achieve is to retain the first 10 characters of each cell, without any spaces, and all in upper case.
I've attached a sample doc of how it's supposed to look, before in column A and after in column B. However, I do not want it to be placed into a new column, but instead replacing the existing values in column A.
Any help would be greatly appreciated! Thank you!
2116421164
I'm having trouble with creating the code for the left function in VBA.
What I am trying to achieve is to retain the first 10 characters of each cell, without any spaces, and all in upper case.
I've attached a sample doc of how it's supposed to look, before in column A and after in column B. However, I do not want it to be placed into a new column, but instead replacing the existing values in column A.
Any help would be greatly appreciated! Thank you!
2116421164