How to add a single letter to the end of an growing number

[jdaub]

I have a scale ticket Excel Sheet and in the sheet is a macro called clear ticket when this is pressed it grows the number by 1 by using this code Range("B3").Value = Range("B3").Value + 1 I would like to add a letter to the end of the number so there are no duplicate scale ticket numbers since two different PCs utilize this excel sheet. Is it possible to add a letter at the end of this growing number? If any other info is needed please let me know!

[Dave]

Range("B3").Value = Left(Range("B3").Value, Len(Range("B3").Value)-1) + 1 & "A"

HTH. Dave
ps. Welcome to this forum.

[jdaub]

That worked perfectly!! Thank you so much for your help!!!

[Dave]

You are welcome. Thanks for posting your outcome. Dave