Concatenate the strings to text in a range if the text length is less than 7
I have a range that contains some text. Each text has a length of 6 (ex: “301.12”, “301. 84″, 301.12”) and 7 (ex: “301.134”, “301.446”, “217.319”). How to add 1 string to a text with a length of 6 so that the length of the text becomes 7 in VBA Excel?