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?

Text in the range:

301.12
301.84
301.12
301.134
301.446
217.319

Expected text:

301.12X
301.84X
301.12X
301.134
301.446
217.319