Text macro not working properly

Hi there Everyone! I have a small problem with an easy macro.
The problem is the following. I have a code number (L256) and when I run the macro I would like to get the nex code in line (which in this case is: L257). The macro I wrote works fine the problem is that it puts a space between the "L" letter and the number so it looks like (L 257, and it should be L257). Why is that happening?? Please find attached the file with the macro.

Thank you in advance for your help!

Sorry, I forget to add the file. Here it is..please find attached.

Hi

You don't need to use the Str function (the leading space is reserved for the sign of the number, blank if positive).

You could alternatively use something like:

Please Login or Register  to view this content.

Richard

) Thanx a lot guys!!! It's working! ) Thank you, thank you, thank you!